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

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

Is Sql non procedural query language?

1 Answers   Verifone,

What is model database? : SQL Server Architecture

0 Answers  

Explain for xml explicit mode?

0 Answers  

Can two tables share the same primary key?

0 Answers  

Find first and last day of current month in sql server

0 Answers  

Write a sql query to delete duplicate records from a table called table1

0 Answers  

Explain index in sql server?

0 Answers  

How to find related tables in sql server?

0 Answers  

What command do we use to rename a db?

5 Answers   IBM,

Can we hide the definition of a stored procedure from a use?

0 Answers  

How to know whether our backup is succesfully taken?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories