Wednesday , January 17 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

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …

%d bloggers like this: