Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

Question Posted / jabamit

Answers were Sorted based on User's Feedback



WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX..

Answer / jabamit

CLUSTER INDEX BCZ THAT WORK PHYSICALLY(MEANS ALREADY IN DEC
OR ASC ORDER) BUT NON CLUSTER INDEX WORK DYNAMICALLY.

Is This Answer Correct ?    15 Yes 3 No

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX..

Answer / ashu_jsr

Cluster Index will be faster because data is already sorted
wrt to the index, hence you get the absolute position of
the data, where as in case of noncluster index the relative
position is given by the index

Is This Answer Correct ?    7 Yes 0 No

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX..

Answer / shaurabh thapa

Cluster Index is faster because it has data in the leaf
nodes along with the key. Non cluster on the other hand uses
cluster index key to search the data and therefore
relatively less fast.

Is This Answer Correct ?    10 Yes 8 No

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX..

Answer / g.ashok

Non clustered index is fast

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL Server Interview Questions

what is maximum size of temp db?

4 Answers   iSoft,

What is the recovery model? List the types of recovery model available in sql server?

0 Answers  

Explain system views?

0 Answers  

What is the difference between composite index and covering index?

0 Answers  

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

Is there any difference between the primary key and unique key?

0 Answers  

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

0 Answers  

What is a view?

6 Answers  

How do I run a trace in sql server?

0 Answers  

What is set nocount on?

0 Answers  

How to divide query output into multiple groups with the group by clause in ms sql server?

0 Answers  

Why should we go for stored procedures? Why not direct queries?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories