What are the type of Indexes? which one is best, why?
Answers were Sorted based on User's Feedback
Answer / arun pandey
Hi
1)Clustered Index
2)NON-Clustered INdex
But Clustered index is better than non-clusted
becoz the searching in clusterd is faster than non-clustered
Arun Pandey
A1Technology
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / jay vardhan singh
Cluster is faster then non cluster index.We can use only
one cluster index on one table and we can use more then one
non cluster index on one table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / a.ganesh
not only two type, more type of indexes there
such as Clustered Index with Primary And Index with Uniqu
Is This Answer Correct ? | 0 Yes | 0 No |
What is scrollable cursor?
What extended events?
How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...
What do you understand by recursive stored procedure?
List the different types of joins?
Does order by actually change the order of the data in the tables or does it just change the output?
What are scalar functions in sql?
What is transact-sql ddl trigger?
What is the purpose of indexing?
Can you create a logon trigger in sql server 2005 express edition?
Difference between drill down and drill through report.
Is port 1433 secure?