Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10113 Views
- Satyam, I also Faced
- E-Mail Answers
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
Determine when to use stored procedure to complete sql server tasks?
what is the primary use of the model database? : Sql server administration
Do you know what guidelines should be followed to help minimize deadlocks?
What is normalization of database? What are its benefits?
How to scale out a federation by Sql statement?
How to choose all records from the table?
How to create a new table in a given schema?
What is difference between getdate and sysdatetime in sql server 2008?
Why use sub query in sql server and list out types of sub queries?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What are the essential components of sql server service broker?
What are the purposes of floor and sign functions?
Can we use where and having clause together?
What is the process of indexing?
Why use view instead of a table?
