Interested to Buy Any Domain ? << Click Here >> for more details...
Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 8797 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 is the difference between locking and multi-versioning?
What are the key configuration files for sql server reporting services ?
What is unpivot?
Difference between LEN() and DATALENGTH() in sql server ?
What is the sql profiler?
What is a heap?
What is postgresql server?
Do you know what is a trace frag? Where do we use it?
Explain in brief about Microsoft SQL server?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Why main is user defined function?
What are the functions in sql server?
What is indexing in sql server with example?
How to add code to the existing article (using improve article)?
Explain about unique identifier data type in sql server?
