Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10040 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
How to list all stored procedures in the current database using ms sql server?
Explain in details security in SQL azure?
What are the differences between left join and inner join in sql server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is the standby server?
what is database replicaion? : Sql server database administration
What is an etl file?
What is used to replicate sessions between instances in coldfusion clusters?
How do I view a procedure in sql server?
What is importing utility?
What are secondary xml indexes?
Can a table be moved to different filegroup?
Write an sql query for deleting duplicate rows?
How do I create a stored procedure in sql server?
How to check if stored procedure is running in sql server?
