Interested to Buy Any Domain ? << Click Here >> for more details...
diffrence between Cluster Index and non Cluster Index
- 3 Answers
- 6326 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
What is the purpose of floor function?
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?
What is bit data type? What's the information that can be stored inside a bit column?
What are the steps you can take to avoid “deadlocks”?
Explain the rules for designing files and file groups in sql server?
What are the different normalization forms?
What is exporting utility?
Determine when to use stored procedure to complete sql server tasks?
What are the different types of indexes?
What is de-normalization in sql database administration? Give examples?
Do you know what are different types of replication in sql server?
Describe and explain about SQL native client?
What happens to a statement batch if there is a compilation error?
Explain what are various ways to enhance the ssrs report?
What is the difference between executequery () and executeupdate ()?
