When do you create cluster and noncluster index?
Answer Posted / jerry joseph
A table can have 1 clustered index and 249 non-clustered indexes
indexes make sorting efficient
generally clustered index is ideal for the Primary Key
non-clustered indexes are ideal for columns which are used
in sorting (the columns in OrderBy)
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Write an sql query for deleting duplicate rows?
What is inner join? Explain with an example?
What extended events?
What is the use of builtinadministrators group in sql server? : sql server security
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
What is SubQuery in SQL Server 2008
What are types of scd? : sql server analysis services, ssas
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are the differences between char and varchar in ms sql server?
What is the difference between implicit and explicit transaction?
What is dimension table? : sql server analysis services, ssas
Which are the third-party tools used in sql server and why would you use them?
What do you understand by recursive stored procedure?
Can you name some of the dml commands in sql?
What is the difference between a check constraint and a rule?