Monday , December 10 2018
Home / DataBase / SQL SERVER / When SQL Server Uses Indexes:

When SQL Server Uses Indexes:

When SQL Server Uses Indexes:
Sql sever uses indexes of a table provided the select or update or delete statement contained “where” condition
in them and more over the where condition column must be a indexed column.
If the select statement contain an “order by” clause also indexes will use.
Note:- When sql sever is searching for information under the database first it verifies the best execution plan
for retriring the data and uses that plan which can be either a full page scan or index scan also.

 

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …