What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 35463 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / meera
Clustered index is unique for a table and 249 non-clustered
can be created.The leaf contains data and in non-clustered
the keaf node contains reference to the data.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What you can do to delete a table without the delete trigger firing?
Write SQL queries on Self Join and Inner Join.
How to find related tables in sql server?
What are the different types of cursor?
Do you know hot add cpu in sql server 2008?
Explain transaction server explicit transaction?
Tell me what is de-normalization and what are some of the examples of it?
What is sql server programming?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
How to display a past time in days, hours and minutes?
What is the data tier application?
How to list all columns in a table using odbc_columns()?
What is database isolation in sql server? : sql server database administration
Do you know what is a trace frag? Where do we use it?
