Interested to Buy Any Domain ? << Click Here >> for more details...
diffrence between Cluster Index and non Cluster Index
- 3 Answers
- 6337 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
Do you know what are pages and extents? : SQL Server Architecture
How to enter unicode character string literals in ms sql server?
Explain for xml explicit mode?
What does the on delete cascade option do?
How many replicas are maintained for each sql azure db?
Using the customer, and order table in northwind database, please write a query to produce xml?
what is the difference between a primary key and a unique key? : Sql server database administration
Which is better statement or preparedstatement?
Explain sql server authentication modes?
How can you fetch alternate records from a table?
When would you use the stored procedures or functions?
What is the difference between the 2 operating modes of database mirroring?
How to list all triggers in the database with sys.triggers in ms sql server?
Why we use the openxml clause?
What is sub-query in sql server? Explain its properties.
