What are the type of Indexes? which one is best, why?
- 6 Answers
- 8551 Views
- I also Faced
- E-Mail Answers
Answer Posted / jeff jordan
1) Clustered Index
2) Non-Clustered Index
I'm assuming by "which one is best" we mean which has the
faster look ups. This would be the clustered index since it
is the physical ordering of the rows and the non-clustered
index is like a lookup table. With the clustered index one
you've found the index you've found your row...
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is not null constraint?
Why do we use non clustered index?
What is master database? : SQL Server Architecture
What is transact-sql language?
What is the language structure to add a record to a table?
What is mean by candidate key?
How can you find out how many rows returned in a cursor?
Where the sql logs gets stored?
What is the difference between insensitive and scroll cursor?
What is the difference between online clustering and Offline clustering?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
Can we add our custom code in ssis?
Define left outer join in sql server joins?
What is schemabinding a view?
Why olap is used?
