Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10144 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
Are semicolons required at the end of sql statements in sql server 2005?
What is difference between commit and rollback when used in transactions?
Is INSTEAD OF trigger directly applicable to Table ?
What is a transact-sql statement batch in ms sql server?
Explain the steps to create and execute a user-defined function in the sql server?
What is the difference between set and select?
What is order of B+tree?
How do you create a clustered index?
What are the steps you should follow to start sql server in single-user mode?
Difference between connected and disconnected database in .net with sql server?
Does the unique constraint create an index?
What are the different types of replication you can set up in sql server?
Explain about Views?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Detail about query optimizer?
