Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10128 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
What are different replication agents and what's their purpose? : sql server replication
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is equi join with example?
When we should use and scope of @@identity?
How retrieve field names from the table in SQL through JAVA code?
What you can do to delete a table without the delete trigger firing?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to verify a login name with sqlcmd tool?
what is a correlated sub-query? : Sql server database administration
What Are the Main Features of SQL Azure?
What is the purpose of forms?
What is the fillfactor concept in indexes?
How to assign null values to variables or columns?
What is a self join in sql server?
Describe in brief databases and sql server databases architecture.
