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
What is difference between inner join and full join?
How to write a query with a full outer join in ms sql server?
Are resultset updatable?
Can we write ddl in trigger?
What is SQL Azure Data sync?
What is query processing?
How can change procedure in sql server?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What are “lock” hints?
What the different components in replication and what is their use?
What is @@rowcount in sql?
Can I delete event logs?
What is the difference between having clause and where clause in sql server?
Define right outer join?
What do you think of this implementation? Can this be implemented better?