Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 7444 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 stored by the master?
What do you mean by data manipulation language?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
Is it possible to create trigger on views?
What is DCL?
Explain what is the difference between union and union all?
What is the use of keyword with encryption. Create a store procedure with encryption?
According to you what goes into making the best database administrator? : sql server database administration
What is the query and subquery?
What is the purpose of the master database?
do views contain data ?
Explain contrast amongst grouped and non-bunched records?
What is the stuff and how does it differ from the replace function?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is the contrast amongst drop and truncate?
