Difference between Cluster and Non-cluster index?
Answer Posted / p.karthick
clustered index is physically stored
a table can have 1 clustered index
non clustered index is logically stored
a table can have 249 non clustred index
| Is This Answer Correct ? | 193 Yes | 46 No |
Post New Answer View All Answers
How to verify the port number of the sql server?
How to create and drop temp table in sql server?
can an order by clause be used in a creation of a view?
How to drop existing indexes in ms sql server?
Is ssrs support other database except ms sql server?
Tell me what is the significance of null value and why should we avoid permitting null values?
How do I start sql server agent automatically?
What is sql server 2000 work load governor?
Do you know nested transaction?
How to query multiple tables jointly?
Can two tables have the same primary key?
When I run the sql server 2000 setup, it just hangs. What do I do?
Explain identity in sql server?
How to find the list of fixed hard drive and free space on server?
What is the minimum recommended amount of ram for sql server 2012 enterprise?