We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?

Answer Posted / laxman

we need to use indexed column in where clause

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how you can deploy an ssrs report?

127


What is sql sandbox in sql server?

631


How to attach adventureworkslt physical files to the server?

644


Do you know what is lock escalation?

594


What happens when unicode strings concatenate with non-unicode strings?

552






What happens if null values are involved in string operations?

565


Explain can SSRS reports Cache results?

112


How to define and use table alias names in ms sql server?

571


List the various tools available for performance tuning?

490


What are the different types of locks in the database?

493


How to verify the port number of the sql server?

565


How do I get Report Builder to generate a parameter that can be set by users viewing the report?

100


Define left outer join?

598


What is meant by Active-Passive and Active-Active clustering setup?

579


What are distributed partitioned views?

630