diffrence between Cluster Index and non Cluster Index
- 3 Answers
- 5530 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / indraneelandhavarapu
The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Write a sql query to sort on different column name according to the parameters passed in the function?
How can you insert null values in a column while inserting the data?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Why normalization is used?
What are the purposes and advantages stored procedure?
Explain sub-query?
What is store procedure?
What is data modeling and Reterminal integrity?
Benefits of Stored Procedures?
Explain having clause and where clause?
What is the temp table?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Tell me what is difference between view and materialized view?
Define the one-to-one relationship while designing tables.
What is difference between getdate and sysdatetime in sql server 2008?
