Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10121 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
Explain try...catch with sql server?
What are the different index configurations a table can have?
What are system databases into sql server (2005/2008)?
Define compound operators?
What is a performance monitor?
How do I uninstall sql server 2014?
Explain features of analysis services?
Explain what you mean by 3 tier architecture.
What is sql server locking?
do views contain data ?
What do you understand by SQL*Net?
What do mean by xml datatype?
How to edit table in sql server 2017?
List the different types of joins?
Which rendering formats are affected by the pagesize properties?
