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
Is mysql better than sql server?
What are the advantages of user defined function?
What is collation sensitivity?
What are different replication agents and what's their purpose? : sql server replication
What command would you use to add a column to a table in sql server?
Name few endpoints exposed by ssrs 2012?
Is oracle faster than sql server?
What are the properties of sub-query?
Can you insert NULL in unique column?
what stored procedure would you use to view lock information? : Sql server administration
What are points to remember while using the fillfactor argument?
What are subquery and its properties?
What is coalesce in sql server?
Explain the creation and execution of a user-defined function in the sql server?
What does it mean to invest in the index?