Answer Posted / rajkumar
There can be only 1 Clustered index in a table
where as nonclustered index can be upto 249
Clustered is physical sorted index..
non clustered is logical stored index is faster than
clustered index
thats all i know
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is microsoft sql server?
explain the storage models of olap? : Sql server database administration
How to concatenate two strings in SQL Server.
What program is used to store the data source file?
what are user defined datatypes? : Sql server database administration
How do use Having,Group by,Group function in SQL?
Can we call stored procedure in trigger?
What is tabulation?
How would you add a section to a table?
Explain external key management in sql server 2008
What is “asynchronous” communication in sql server service broker?
What is indexed view? How to create it?
How do I view views in sql server?
What are the different authentication modes in sql server?