Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54802 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / kaushik ganguly
We know sql server creates a clustered index by default
when we create a primary key. If you create a PK first and
then try to assign a candidate key a clustered index then
it is not possible bcos sql server allows one clustered
index per table.
But...
If you make a candidate key a clustered index and then
define the primary key sql server doesnot create clustered
index for the Primary Key column.
So the answer is yes...you can create a clustered index on
non-pk column :D
| Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
What is a constant or literal in ms sql server?
What is a full text index?
Some queries related to SQL
what method you can use to reduce the overhead of Reporting Services data sources?
What is buffer cash in sql server?
What are logical/boolean operations in ms sql server?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How can we determine what objects a user-defined function depends upon?
Sql server reporting services vs. Crystal reports.
What are the different types of replication are there in sql server 2000?
What is used to replicate sessions between instances in coldfusion clusters?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is the difference between indexing and hashing?
Does table partitioning improve performance?
What is stretch database in sql server?
