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
How to change the name of a database user?
Which data type columns are the best candidates for full-text indexing?
Do you know what is a linked server in sql server?
What is shrink log file?
When would you use it?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Why should you use or avoid select * statements?
Why I am getting this error when dropping a database in ms sql server?
What are the new data types are introduced in sql 2000?
If a stored procedure is taking a table data type, how it looks?
Which tools are available to manage SQL Azure databases and servers?
why would you call update statistics? : Sql server database administration
How to run queries with sql server management studio express?
What is the return type of executeupdate ()?
What kind of problems occurs if we do not implement proper locking strategy?