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

why cluster and non clusterindex are used in sqlserver 2000?
explain with example

Question Posted / preethi


why cluster and non clusterindex are used in sqlserver 2000? explain with example..

Answer / venkat

Index is commonly used for faster data retrieval.We can
have only one Clustered Index and many non-clustered index
in a single table.It is known that there is some
limitations in using indexes.If a column is defined as
primary key,by default column is set to be clustered
index.All other indexes created manually in the same table
were non-clustered index.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More SQL Server Interview Questions

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

How can I tell if sql server is 32 or 64 bit?

0 Answers  

How raid can influence database performance?

0 Answers  

Explain Different types of Projects?

1 Answers  

what is a cursor and what is its use?

2 Answers   L&T,

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

What is the command dbcc checkdb used for?

0 Answers  

What does top operator do?

0 Answers  

Differences between Standby Vs No recovery?

2 Answers   Wipro,

what information is maintained within the msdb database? : Sql server administration

0 Answers  

What is Outter Join?

1 Answers  

How to create a ddl trigger using "create trigger" statements?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories