We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?
Answer Posted / ish
It is depend on which type of indexing u r using .
clustered or non clustered.
if u r searching one record then used nonclustered indexing.
if u r searching bulk of record then used clustered indexing
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain nested join?
Data table as parameter in sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
Is it safe to delete log files?
What is service broker?
Explain the benefits of user-defined functions?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is the difference between local and global temporary tables?
What is statement level trigger?
How to attach adventureworkslt physical files to the server?
What is trigger in salesforce?
What are the requirements to use odbc connections in php scripts?
What is the difference between the 2 operating modes of database mirroring?
How many full-text indexes can a table have?
What is BCNF? How is it better than 2NF & 3NF?