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
What is mapping schema?
How to test odbc dsn connection settings?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is difference between primary key and foreign key?
Define right outer join in sql server joins?
how can you check the level of fragmentation on a table? : Sql server administration
What is in place upgrade in sql server?
What is forward - only cursors / read only cursor?
What is thr feature of change data capture?
What is data source object?
Describe the functionalities that views support.
How do you start single user mode in clustered installations?
Distinguish between nested subquery and correlated subquery?
Can we insert data if clustered index is disabled?
What do you mean by 'normalization'?