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
What is transactional replication?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
How to list all login names on the ms sql server?
What is the partitioning method?
What is blocking?
Define self join in sql server joins?
Do you know what is replace and stuff function in sql server?
What is report snapshot in ssrs?
What are the limitations in ssrs on sql server express edition?
What are the new features of sql server 2012 reporting service?
How to write a query with a right outer join in ms sql server?
How to create an index on an existing table in ms sql server?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
How much memory that we are using in Logshipping Concept?
What is self join in sql server joins?