Difference between Cluster and Non-cluster index?
- 32 Answers
- 138509 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / moin khan
Clustered Index
1. Only one per table
2. Faster to read than non clustered as data is
physically stored in index order
Non Clustered Index
1. Can be used many times per table
2.Quicker for insert and update operations than a
clustered index
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How many columns can we include on clustered index ?
Explain having clause?
What is sql server profiler?
How to find out the list schema name and table name for the database?
What are the Advantages of using CTE in sql server?
What is a trigger and its types?
Write SQL queries on Self Join and Inner Join.
What is ms sql server index?
How to write a query with an inner join in ms sql server?
Explain Capacity planning to create a database? and how to monitor it?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
can any body tell me how to know the password of current user in sql server
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
How to backup encryption key ?
