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...

what is cluster and nin-cluster index?

Answer Posted / rajkumar

There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249

Clustered is physical sorted index..

non clustered is logical stored index is faster than
clustered index

thats all i know

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is right outer join in sql server joins?

1222


What is default constraint in ms sql server?

1106


What causes index fragmentation?

1047


What is the purpose of forms?

1004


How to count duplicated values in a column in ms sql server?

1171


What is linked report?

137


What are different types of join?

1378


What is correlated subquery in sql server?

1127


What is read uncmmited?

1118


How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1152


Why do you need a sql server?

1173


What the different components of Replication and what is their use?

1128


What are advantages of ssrs or why we should use ssrs?

145


How to create a Master database in SQL server ?

1143


Explain error handling in ssis?

1078