When do you create cluster and noncluster index?
Answer Posted / nandkumar karlekar
Create the Clustred index when your data are divided into
some countable infinite limited sets which helps to retrive
the set of date from continus data pages from h/d.
because the clustred index stores data physically.
we can create only one clustred index for a table.
reaming searching field can be included in to the non
clust.. index
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me what is the significance of null value and why should we avoid permitting null values?
What is transactional replication?
Describe and explain about SQL native client?
What is the use of toad or sqldbx.?
What is the difference between a fill factor of 100 and 0?
Explain full-text indexing?
Can you explain what are various ways to enhance the ssrs report?
What stored by the msdb? : sql server database administration
How can you append an identity column to a temporary table?
What is difference between table aliases and column aliases? Do they affect performance?
How do I create a trace in sql server?
What are the different types of replication are there in sql server 2000?
What is normalization? Explain its different types?
What is the difference between getdate and sysdatetime?
What have included columns when we talk about sql server indexing?