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 to create a view with data from multiple tables?

567


What are the advantages of partitioning?

657


What is the full meaning of dml?

534


What is the return type of executeupdate ()?

533


What is the sql server agent?

593






Explain a join?

627


Explain syntax for viewing, dropping and disabling triggers?

516


What are out-of-range errors with date and time literals?

560


What Is Rdbms?

684


How to delete an existing database user?

545


Define Joins?

621


What happens if ntwdblib.dll is missing on your machine?

644


Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

573


how to define testing of network layers? : Sql server database administration

500


What purpose does the model database server?

668