Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 9876 Views
- Satyam, I also Faced
- E-Mail Answers
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 the difference between clustered and non-clustered index?
How you can add messages to the nt event log from within a stored procedure?
How to delete duplicate rows from table except one?
What is difference between unique and primary key?
What are the indexes in sql server?
Explain what is it unwise to create wide clustered index keys?
How many types of triggers are there?
How to disable a login name in ms sql server?
How do I find the default sql server instance?
Does sql server use t sql?
What are dml triggers and types of dml triggers?
how can you attach more than 20 ldf files in sql server
According to you what goes into making the best database administrator? : sql server database administration
what are constraints? Explain different types of constraints? : Sql server database administration
Explain the different index configurations a table can have?
