What is the basic difference between clustered and a
non-clustered index?
Answer Posted / meera
Clustered index is unique for a table and 249 non-clustered
can be created.The leaf contains data and in non-clustered
the keaf node contains reference to the data.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
What are commit and rollback in sql?
How can sql server instances be hidden? : sql server security
What are a database and a data warehouse?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to create new tables with "select ... Into" statements in ms sql server?
What do you mean by cardinality?
Explain steps of normalization?
Mention what are the core components of ssrs?
What is the default sql server instance name?
What is sharding?
What are the purposes and advantages stored procedure?
What is the process of normalising?
State a few properties of relational databases?
How can I create a new template for import ? : sql server management studio
What are trace files?