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 functions and stored procedures?
What are the different types of data sources in ssrs?
Tell me about builtinadministrator?
Explain different backup plans?
Explain powershell included in sql server 2008?
How to disable a login name in ms sql server?
What is change tracking in sql server?
What is the maximum number of index per table?
Explain collation?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
Is null vs coalesce?
Explain what is analysis service repository?
Explain alternate key, candidate key and composite key in sql server?
What is a fan-out query in SQL Azure?