Interested to Buy Any Domain ? << Click Here >> for more details...
We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?
- 3 Answers
- 5706 Views
- I also Faced
- E-Mail Answers
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 a full text index?
How the authentication mode can be changed?
Does index speed up select statements?
What is equi join with example?
What are the advantages of using cte?
How do you rebuild an identity column?
Can I use sql azure as a backup with log shipping or database mirroring?
How to use group functions in the select clause in ms sql server?
What are the types of ssrs?
What is xdr?
What is difference between sql and sql server?
What is RAID? What are the different types of RAID configurations?
What is a transact-sql statement batch in ms sql server?
Using the customer, and order table in northwind database, please write a query to produce xml?
What are cursors and when they are useful?
