Answer / honnur swamy

A clustered index sorts and stores the data rows in the
table based on the index key values. Therefore only one
clustered index can be created on each table because the
data rows themselves can only be sorted in one order.

Answer / samrat sen

Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.

Answer / abhijit

A clustered index sorts and stores the data rows in the
table based on the index key values. Therefore only one
clustered index can be created on each table because the
data rows themselves can only be sorted in one order.

Answer / shailesh arban

Because cluster index sort data in table based on key value that is you primary key value and primary key values are unique in table therefore cluster index only one on table.

Answer / jai

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

Answer / samrat sen

yes,you can only create one clustered index on a table.

Answer / muthu

Clustered index based on Primary Key. So if we create a PK,
automatically Clustered Index will be created. So only one
CI available for a table.

Answer / raju.r

we can create ony ONE clustered index per table .. for Non-
clusrtered index we can create 249 ...

How to delete existing triggers using "drop trigger"?

0 Answers  

What is scheduled job and how to create it?

0 Answers  

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

Explain contrast amongst grouped and non-bunched records?

0 Answers  

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

Diffrent types of function

1 Answers   Wipro,

Mention the uses of stored procedures.

0 Answers  

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

What is difference between order by and group by?

0 Answers  

What is difference between join and natural join?

0 Answers  

About Indexed Views? with example? plz reply...

2 Answers