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

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

Is it possible to call a stored procedure within a stored procedure?

0 Answers  

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

What are logical/boolean operations in ms sql server?

0 Answers  

Explain triggers in sql?

0 Answers  

Which is better statement or preparedstatement?

0 Answers  

What is a function? Give some example?

3 Answers  

What do you mean by data manipulation language?

0 Answers  

What are the types of constraints?

1 Answers  

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

What is meant by referential integrity?

0 Answers   Blue Star,

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

For more SQL Server Interview Questions Click Here
Categories