What are the type of Indexes? which one is best, why?
Answer Posted / 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 |
Post New Answer View All Answers
Define Wed Edition in SQL Azure?
What is the use of sign function?
What is the need for indexing?
What are user defined functions in ms sql server?
How to update multiple rows with one update statement in ms sql server?
Which tcp/ip port does sql server run on? How can it be changed?
What is sub query and its properties?
What are logical database components? : SQL Server Architecture
Explain what is lock escalation and what is its purpose?
How to make remote connection in database?
Can You Use Data Mining Models In Ssrs?
How do I trace a query in sql server?
What is 'write-ahead log' in sql server 2000 ?
How to bind a view to the schema of the underlying tables?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?