Answer / pravin ahire

Clustered index:
1) A table can have only One clustered index
2) clustered index created on primary key only.
3) It is physical order and it is same order stored on disk.
4) clustered index is fast index than no-cluster index.

Non-clustered index:
1) A table can have only more than one non-clustered index
2) clustered index created on unique key.
3) It is logical order and it is not same order stored on disk.
4) Non-clustered index is slow index than cluster inde

Answer / rahul

A) Creating a clustered index on a table re-arranges the data in a sequential manner. while creating clustered index, certain guidelines must be followed. They are:

1) Queries should return a range of values by using operators such as, BETWEEN, > , >= , < and <=.

B) Non-clustered index is created on a table, the data is not physically re-arranged in sequential order.

Answer / prakash

Cluster index :-

1) CLUSTERED INDEX IS PHYSICALLY STORED THE DATA.

2)ONE TABLE CAN HAVE ONLY ONE CLUSTERED INDEX
BECAUSE IT STORED IN ORDER OF THE CLUSTERED KEY.

3)CREATING A CLUSTERED INDEX ON A TABLE RE-ARRANGES
THE DATA IN A SEQUENTIAL MANNER

4)ONCE WE DEFINED A COLUMN WITH PRIMARY KEY CONSTRAINT, SQL
SERVER AUTOMATICALLY CREATES UNIQUE CLUSTERED INDEX ON THAT
COLUMN




5) THE LEAF LEVEL OF A CLUSTERED INDEX IS THE ACTUAL
DATA


__________________________________________________________
NON-CLUSTERED INDEX:-

1)NON- CLUSTERED INDEX IS LOGICALLY STORED DATA.

2) ONE TABLE CAN HAVE 249 NON- CLUTTERED INDEX IN SERVER-2005
AND 999 IN SERVER-2008

3)NON-CLUSTERED INDEX IS CREATED ON A TABLE, THE DATA IS NOT
PHYSICALLY
RE-ARRANGED IN SEQUENTIAL ORDER.


4)ONCE WE DEFINED A COLUMN WITH UNIQUE KEY CONSTRAIN , SQL
SERVER AUTOMATICALLY CREATE NON CLUSTERED INDEX.

5) NON-CLUSTERED INDEX THE LEAF LEVEL IS
ACTUALLY A POINTER TO THE DATA IN ROWS

Answer / bala murugan28

IN SIMPLE WORDS,
CLUTER INDEX IS PHYSICALY STORED ONE.

NONCLUSTER INDEX IS LOGICALLY STORED ONE.

Answer / upma

when u create primary key in a table than cluster index are automatically created...becoz there can b only one primary key on a table,so cluster index is one in a table.cluster index reorder the way records in a table are physically stored...
Non cluster index,when u create unique automatically generated... 249 non cluster index in a table,because we can apply more than one unique key in a table..
logically order, does not match with physical order..

Answer / vikram kumar

The biggest difference between a clustered index and a non-
clustered index is that when you use a clustered index, the
section of the table that comprises the index has its data
pages linked differently from those data pages comprising a
non-clustered index.

In SQL Server 2005 you'll probably hear the term "heap or B-
Tree."

Answer / div

Cluster index directly represents the physically stored
data. So their order will be the same as and when they are
populated into the table. Accessing this data will be
faster.

Non-cluster index just provides a pointer to the data.
Accessing this data will be slower when compared to the
clustered data.

Answer / ricky

when we create a primery key it automatically create
aclustered index. clustered index is a index which reorder
the records in a way the recored are physically sorted.
or
in clustered index the logical order match the physical
order.
whre as the non-clustered index the logical ordered of the
recored does not match the physical order of the recored on
disk.

Answer / veerreddy

clustered index is that the order of data in table is always
equal or matches to order of data stored in index.there is
only one(1) clustered index for table.it is usually applied
on primary key column in table.

other hand the non-clustered index is that the order of data
in table is not equal or matches to order of data stored in
index.so they can be applied on non-primary key columns like
unique,foreign key etc.A table can have (249) non-clustered
indexes

Answer / jagan

Clustered Index:- It reorder the table phyically and stores
data in a DATA PAGE. DATA PAGE is nothing but page contains
all the data in correct order.Indexing is known as index in
a book(titles with page number).It helps the SQL SERVER to
retrive the data quickly and make the query to perform
fastly.Only 1 index for a table.

Non Clustered Index:- Index that is created in any order.
we can create up to 249 in a table.Indexing is known as
index in a book(titles with page number). performance will
be little bit less than the clustered index.

What is sql server used for?

0 Answers  

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

In which situation you use Self joins?

1 Answers   CarrizalSoft Technologies, HP, TCS,

What are the advantages of paper records?

0 Answers  

How many types of cursor type are there?

0 Answers  

What is a collation?

0 Answers  

Explain difference between control flow and data flow?

0 Answers  

What’s the use of custom fields in report?

0 Answers  

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

How to drop an existing schema in ms sql server?

0 Answers  

How check triggers in sql server?

0 Answers