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 do I find the sql server version?
What is lock escalation? : sql server database administration
Describe the functionalities that views support.
Explain sql server service broker?
What is default constraint?
What do you mean by an execution plan? How would you view it?
Which data type columns are the best candidates for full-text indexing?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What are the restrictions applicable while creating views? : SQL Server Architecture
Explain how to use linked server?
What is bulkcopy in sql?
Data table as parameter in sql server?
How many types of attribute relationships are there? : sql server analysis services, ssas
What is the command dbcc checkdb used for?
What do you understand by a view? What does the with check option clause for a view do?