Interested to Buy Any Domain ? << Click Here >> for more details...
diffrence between Cluster Index and non Cluster Index
- 3 Answers
- 6068 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 contrast amongst drop and truncate?
How to stop log file growing too big?
How raid can influence database performance?
How to recreate an existing index in ms sql server?
What is tempdb in sql server?
What is abstracting periodical?
Can primary key be a foreign key?
how many type of indexing in database?
Which autogrowth database setting is good?
Why do we use stored procedures in sql server?
SQL Server Architecture ?
Mention the differences between sql server and mysql.
Mention the differences between having and where clause.
What is an active database?
Explain about sql server login?
