Difference between Cluster and Non-cluster index?
Answer Posted / james bond
All are mad with cluster index.
they don't know wht the exact difference.
(All these are book worm.they just a ctrl+C and Ctrl+v and
nothing else)
Clustered index proper way to findd desired data like
rowndex(physical form of data) and non clustered is
mapping of these clustered index in differnt form.
(Don't try to keep as written on your mind. think it and
then use it??)
| Is This Answer Correct ? | 62 Yes | 63 No |
Post New Answer View All Answers
Can you get second highest salary from the table?
How to achieve Paging of records in SQL SERVER?
What is an indice?
How to reaname table name without using sp_Rename in sql server..?
How does recursive cte works in sql server?
What you can do to delete a table without the delete trigger firing?
How to get a list of columns in a view using the "sp_help" stored procedure?
How to transfer a table from one schema to another?
How can I change procedure name in sql server?
Explain time data type in sal server 2008?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Are all views updatable ?
What do you mean by tablesample?
What is purpose of normalization?
How to defragment indexes with alter index ... Reorganize?