Answer / yashpal

Clustered index will be created by default when u
create primary key on a column. only one clustered index is
created per table

Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.

Answer / ankit murela

cluster index:- (1)only one cluster index can be created.
(2)sort the data physically.
(3)Applied on columns which are not modifier frequencely.
(4)the leaf nodes of a cluster index contain the data pages

non-cluster index:- (1)there can 249 non cluster index per table.
(2)does not sort the data physically.
(3)Applied on columns which are modifier frequencely.
(4)The leaf nodes of a non cluster index does not contain the data pages

Answer / indranil

The clustered index is SORTED, and the nonclustered index is
UNSORTED.

For example, we have a pile of birth certificates in City
Hall, and we're going to make an index by birthday (birth
date, to be more exact.)

With a nonclustered index, it's like you have a bunch of
paper lists, each paper with a date, and the people born
under that date. You can quickly determine all people who
were born on August 4, 1986. However the papers themselves
are not sorted, so if you wanted to know all people born in
1986, or August 1986, you'll have to go through all the papers.

With a clustered index, the birth certificates themselves
are sorted by birth date, so searching for people born in
1986, or August 1986, January-June 1981, or any date range
is much faster. Also, it is easier to sort all the people by
birth date (since the data is already sorted).

Answer / prince

clustered index is hemanth index
and
non clustered index is non hemanth index

Answer / moin khan

Clustered Index

1. Only one per table
2. Faster to read than non clustered as data is
physically stored in index order

Non Clustered Index

1. Can be used many times per table
2.Quicker for insert and update operations than a
clustered index

Answer / ghanshyam vishwakarma

CLUSTER:- cluster like a pointer that point to one page to
another and get the final data.


NON CLUSTERED INDEX:
Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.

Answer / sangram nayak

clustered index: if there is any primary key then then its clustered index.only one clustered index can be possible.

Non clusterd index: whenever you are creating any index on any column then that is non clustered index.multile non clusted index is possible.

Answer / james bond

All are mad with cluster index.
they don't know wht the exact difference.
(All these are book worm.they just a ctrl+C and Ctrl+v and
nothing else)

Clustered index proper way to findd desired data like
rowndex(physical form of data) and non clustered is
mapping of these clustered index in differnt form.

(Don't try to keep as written on your mind. think it and
then use it??)

Answer / 007

I agree with JAMESBOND's reply....thats the exact thing
happening behind the clustered index and non clustered
index. Remaining answers are all Cut and Paste....

Answer / rajeev goel

CLUSTER:- cluster like a pointer that point to one page to
another and get the final data.

NON-CLUSTER:- non-cluster like subpart of any part.
for example- content. in side content another subcontent
and so on......

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

How to specify the collation for a character data type in ms sql server?

0 Answers  

What number sorts of privileges are accessible in sql?

0 Answers  

How many ways to create table-valued functions?

0 Answers  

How to fetch the next row from a cursor with a "fetch" statement?

0 Answers  

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

Explain the disadvantages/limitation of the cursor?

0 Answers  

What is pessimistic concurrency?

0 Answers  

what is replication? where do u use Go Keyword?

1 Answers   Satyam,