Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 9175 Views
- Progressive, I also Faced
- E-Mail Answers
Answer Posted / vijaya
In Clustered Index, the data is physically sorted.
only one Clustered Index is created per table.
The data is stored in heap level of the B-tree.
In non-clustered Index, the physical order of the rows is
not same as the order of index.
there can be upto 249 non-clustered index per table.
the data is present in the random order but the logical
ordering is specified by the index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what's new in sql server 2016?
What is b tree index?
What is difference between equi join and inner join?
Explain collation?
Can the “if update (colname)” statement be used in a delete trigger?
How to list all tables in the database using odbc_tables()?
What is SQL Azure Firewall?
What is the Disadvantage of indexed sequential file.
Which language is supported by sql server?
What are the types of database recovery models?
Explain difference between cross join and full outer join?
What is bcnf normalization form?
Explain four layers of abstraction microsoft architectured?
what is sql server? : Sql server database administration
Can we use having clause without group by?
