Can we create clustered index on non primary key column
Answer Posted / sandeep
Yes, We can, only thing is that, we can create clustered
index only on one key.If table contains any clustered index
on any key(even on primary or on unique key) just drop it
and create it on desired key. after it you can create a non
clustered index on primary or on unique key.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Which are the important points to note when multilanguage data is stored in a table?
What is faster join or union?
How do you delete a data source?
How to sort query output in descending order in ms sql server?
What are a scheduled jobs or what is a scheduled tasks?
What are the new data types are introduced in sql 2000?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is data block and how to define data block size?
What is index in an assignment?
what is difference between NULL and ISNULL in SQL Server 2008?
What is the contrast between sql and pl/sql?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What are different type of Collation Sensitivity?
Does partitioning improve performance sql server?