Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 37845 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / guest
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 ? | 89 Yes | 9 No |
Post New Answer View All Answers
What is the return type of executeupdate ()?
What are the steps you should follow to start sql server in single-user mode?
How can you find out which stored procedures are recompiling?
How many databases instances are there in sql server 2000?
How to see existing views in ms sql server?
What do you know about system database? : SQL Server Architecture
Does table partitioning improve performance?
role of sql sever 2005 in database rather than any other database
what is the difference between count(*) and count(1) ?
Explain subquery and state its properties?
What is a trigger and types of a trigger?
What stored by the model? : sql server database administration
How to encrypt Strored Procedure in SQL SERVER?
Explain how dts is used to extract, transform and consolidate data?
What is after dml trigger?
