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

Explain how does the report manager work in ssrs?

0 Answers  

What is normalization? Explain different forms of normalization?

0 Answers  

Can primary key be null?

0 Answers  

How to return the date part only from a sql server datetime datatype?

0 Answers  

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

Explain what is log shipping?

0 Answers  

SQL Server Architecture ?

0 Answers   IBM, Sapient,

What language is sql server written in?

0 Answers  

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

How to use transact-sql statements to access the database engine?

0 Answers  

What is lookup override?

0 Answers   Informatica,

How to set the current database in ms sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories