Interested to Buy Any Domain ? << Click Here >> for more details...
diffrence between Cluster Index and non Cluster Index
- 3 Answers
- 6216 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 ems sql management studio? : sql server management studio
Is foreign key a primary key?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is a performance monitor?
What are the disadvantages of indexes?
Write an SQL query to obtain the 2nd highest salary.
How to convert numeric values to integers in ms sql server?
What is the security principal at the database level that represents your session?
What is a partition key?
What are joins in sql and what are the different types of joins?
What is database isolation in sql server? : sql server database administration
What does it mean to normalize data?
Explain the microsoft sql server delete command?
What is multilevel indexing?
Write a code to select distinct records without using the DISTINCT keyword.
