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
When we should use @@error?
Explain various On-Delete options in a DB table. Which is the default option?
What are the types of dml?
What number aggregate functions are accessible there in sql?
What are the properties and different types of sub-queries?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How to convert binary strings into integers in ms sql server?
What is an expression in ms sql server?
What is merge join?
What is a document index?
How you can change the database name in SQL SERVER?
What are the basic features of a trigger in ms sql server?
System variable and temporary variables
Explain hostprotectionattribute in sql server 2005?
What is the template in sql?