Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145954 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / jagan
Clustered Index:- It reorder the table phyically and stores
data in a DATA PAGE. DATA PAGE is nothing but page contains
all the data in correct order.Indexing is known as index in
a book(titles with page number).It helps the SQL SERVER to
retrive the data quickly and make the query to perform
fastly.Only 1 index for a table.
Non Clustered Index:- Index that is created in any order.
we can create up to 249 in a table.Indexing is known as
index in a book(titles with page number). performance will
be little bit less than the clustered index.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Which is the latest version of sql server and when it is released?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is b tree index?
Can you name some of the dml commands in sql?
What is instead of trigger sql server?
How to use copy and concatenate commands in SQL?
What are four major operators that can be used to combine conditions on a where clause?
What can be used instead of trigger?
What are the different SQL Server Versions you have worked on?
What is data modeling and Reterminal integrity?
What is snapshot replication?
How does clustered and non clustered index work?
How to list all user defined functions in the current database?
What is a collation in ms sql server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
