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 can delete duplicate records in cte in sql server?
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
What is merge statement?
How to list all tables having unique constraints in any of the columns in a database.
Can we use pragma autonomous_transaction in trigger?
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
What is difference between joins and subqueries?
Do you know what is difference between stored procedure and user defined function?
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
How do you use DBCC statements to monitor various aspects of a SQL server installation?
What are examples of triggers?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?