Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54116 Views
- ABC, CTS, I also Faced
- E-Mail Answers
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
What is partitioned view?
Why use cursor in sql server?
Explain about unique identifier data type in sql server?
Give a example to search fr a string in all stored procedure in sql server.
What action plan is preferred if sql server is not responding?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
wat wil hapn if we give the both read and deny read permission to user?
What does asynchronous call backs means?
What is data block and how to define data block size?
What are different types of replication in sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration
Does table partitioning improve performance?
Comment,Datatypes are unlimited
Can a table be created inside a trigger?
Explain about thread and memory management process of SQL?
