Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38451 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 SQL Azure Firewall?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How raid can influence database performance?
How to create a user name in a database?
What is trigger in salesforce?
what is raid and what are different types of raid configurations? : Sql server database administration
How secure is sql server database?
What is database dimension? : sql server analysis services, ssas
How to get a list of columns in a view using "sys.columns" in ms sql server?
How to use subqueries with the in operators in ms sql server?
What is sql server replication? : sql server replication
How to change the data type of an existing column with "alter table" statements in ms sql server?
Define union, union all, minus, intersect?
Can you explain what are various ways to enhance the ssrs report?
Write a program using SQL queries to find a unique entry in a table.
