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 the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

How can you find out how many rows returned in a cursor?

0 Answers  

What is entity data services?

0 Answers  

What is after dml trigger?

0 Answers  

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

What you can do to delete a table without the delete trigger firing?

0 Answers  

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

What is an indice?

0 Answers  

Which virtual table does a trigger use?

8 Answers   TCS,

How to create view in stored procedure sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories