When do you create cluster and noncluster index?
Answer Posted / monal
Indexes are mainly used for faster retrival of the data
from the table or view.
Primary key is best candidate for creation of clustered
key: reason all the values in Primary Key column would be
unique. Also you can create clustered index on foreign key
column of table which is used quite frequently in the join
condition and on the column which is used frequently in the
where clause of the table.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Explain about SQL server 2005?
What is query cost in sql server?
How to check if stored procedure is running in sql server?
What is the difference between update lock and exclusive lock?
What is reference section?
What is database replication? What are the different types of replication you can set up in sql server?
How to remove duplicate rows from table except one?
Explain having clause and where clause?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What can be used instead of trigger?
Describe and explain about SQL native client?
Explain the relational database management system (rdbms)?
What are the results of running this script?
Explain system scalar functions?