When do you create cluster and noncluster index?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / monal
Indexes are mainly used for faster retrival of the data
from the table or view.
Primary key is best candidate for creation of clustered
key: reason all the values in Primary Key column would be
unique. Also you can create clustered index on foreign key
column of table which is used quite frequently in the join
condition and on the column which is used frequently in the
where clause of the table.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / krimish shah
Table can have only one clusert index. When we create
primary key on a table , it will generate a Cluster index
based on this primary key and physically sort and store the
data in order of clusterd index.
Non Cluster index are used to make search more effiecient
on table for given columns on which we have speicfied non
clustered index. Non cluster index have their own separate
storage.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / naren
If there is primary key in table clustered index created by
default ,other wise non cluster index created .
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
How do I find the transaction log size in sql server?
what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?
What is snapshot replication?
Hi..here i would like to know the Backup and Restore models?
How to use transact-sql statements to access the database engine?
Write a program to fetch first 10 records from a file?
What is the difference between count and distinct count?
What is full form of XP ?
42 Answers Cap Gemini, Infosys, Microsoft, Oracle, Reliance,
what is the output for this query select * from employee where 1=1;
What is difference between inner join and join?
Are semicolons required at the end of sql statements in sql server 2005?
Is resultset an interface?