Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146351 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
Explain the concept of recursive stored procedure.
What is the contrast between sql and mysql?
What is a join in sql?
What are date and time data types in ms sql server?
What are the advantages dts has over bcp?
Explain what is the function of sql server agent windows service?
What is dbcc?
How to list all stored procedures in the current database using ms sql server?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Difference between report and query parameter.
Describe in brief authentication modes in sql server.
What is plan freezing?
How can sql injection be stopped? : sql server security
What are the different types of replication you can set up in sql server?
How to choose all records from the table?
