WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 20565 Views
- I also Faced
- E-Mail Answers
Answer Posted / raju.r
we can create ony ONE clustered index per table .. for Non-
clusrtered index we can create 249 ...
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
What is indexing in sql server with example?
How many triggers are possible per table?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to write character string constants or literals in ms sql server?
How do I completely remove sql server instance?
How to truncate the log in sql server 2012? : sql server database administration
What is sql collation?
Is sql server is free?
what is sql server? : Sql server database administration
What are the dmvs?
What is the difference between locking and multi-versioning?
What are the different methods available under sqlcommand class to access the data?
What are types of storage modes? : sql server analysis services, ssas
Explain sql server service broker?
do views contain data ?
