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

When do u use clustered index and non-clustered index?

Answer Posted / pradeep

To increase the performance of database we can use clustered Index .It will be in sorted order and it is in the form of B tree structure and it won't accept nulls.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain a differential backup?

1010


What is the need for indexing?

952


How to Sync Two SQL Azure Databases?

121


What is mapping schema?

1028


Which database stores information about replication?

1071


List out the differences between the clustered index and non-clustered index in sql server?

1006


Define constraints and give an example of their use?

1041


How to provide login information for a new odbc dsn?

1052


Difference between uniqe index and uniqe constraint?

981


What are the rendering extensions of ssrs?

157


Explain raiserror in sql server?

1029


What are the differences between DDL, DML and DCL in SQL?

1232


State a few properties of relational databases?

1128


List out the differences between global and local temp tables in sql server?

1062


Does partitioning improve performance sql server?

983