adspace


Can we have two clustered index on a table?

Answer Posted / Prachi Sonkar

No, a table can only have one Clustered Index per partition key. However, a table can have multiple Non-Clustered Indexes.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I remove duplicates in two columns?

1188


how many tables will create when we create table, what are they? : Sql dba

1144


What is your daily office routine?

2347


what is sql server agent? : Sql dba

1182


Is primary key clustered index?

1020


Can we rollback truncate?

1074


What is the current version of postgresql?

1179


what is schema? : Sql dba

1151


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2092


Can delete statement be rollbacked?

1056


Does group by remove duplicates?

1112


Is inner join faster than left join?

1278


how to start mysql server? : Sql dba

1268


what is bcp? When does it used? : Sql dba

1057


What is the current version of sql?

1094