Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38204 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / geeta
clustered index is an index that sorts and stores the data
rows in the tables based on their key values.the data is
physically sorted in the table when clustered index is
defined on it. only one clustered index is created per
table.
In Nonclustered index contains the indx key values and the
row locators that point the storage location of the data in
a table. there can be as many as 249 nonclustered indexs
per table.
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
explain the storage models of olap? : Sql server database administration
What is model database in sql server?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is unique key constraint?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Can you explain the disadvantages/limitation of the cursor?
Write a code to select distinct records without using the DISTINCT keyword.
How to create a store procedure with encryption?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
query processing
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is the most common trace flags used with sql server?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
What is replication with database mirroring? : sql server database administration
What is the name of the system variable that returns the number of rows affected by a SQL statement?
