Hi Amit , You can refer these links : https://odetocode.com/articles/237.aspx https://www.red-gate.com/simple-talk/sql/performance/index-selection-and-the-query-optimizer/