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)

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.

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.

Answer / naren

If there is primary key in table clustered index created by
default ,other wise non cluster index created .

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

How to create a simple table to test triggers in ms sql server?

0 Answers  

How many partitions a clustered index has by default in sql server 2012?

0 Answers  

logshipping is Any difference 2000 and 2005?

2 Answers  

what is curser.

9 Answers  

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

What is apply operator in sql?

0 Answers  

How to create stored procedures with parameters in ms sql server?

0 Answers  

Explain the dirty pages?

0 Answers  

Why we need a group by clause?

4 Answers  

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

How reterive duplicate value in SQL?

6 Answers