Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 9184 Views
- Progressive, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
Clustered index is a special type of index that reorders
the way in which the data is pysically stored in table.A
table can have just 1 clustered index.leaf nodes of a
clustered index contains the datapages.
Non clusterd index is also a special type of index in which
the logical order of the index doesnt match physical stored
rows on the disk.A table can have multiple indexes probably
(16).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to provide values to user defined function parameters?
What is partitioned view?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Explain syntax for viewing, dropping and disabling triggers?
Is port 1433 secure?
What is a self join in sql server?
Explain tablesample?
What is row_number function?
What to check if a User database is locked?
What is SQL Server?
What type of Index will get created after executing the above statement?
Tell me what are the essential components of sql server service broker?
What is replace and stuff function in sql server?
How you would rewrite the sql query to return the customerid sorted numerically?
How to see existing views in ms sql server?
