Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10305 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
What is the default Port No on which SQL Server listens?
How to trouble shoot if unable to connect SQL Server
What is the importance of concurrency control?
What command do we use to rename a database?
Do you know what are acid properties?
Tell me about joins in database system and explain each in detail.
What are the functions in sql server?
How can I know what locks are running on which resource?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is sub-query in sql server? Explain its properties.
What is a natural primary key?
What will be the maximum number of indexes per table?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
How to fetch the next row from a cursor with a "fetch" statement?
What are the types of subscriptions in SQL Server replication?
