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

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

Question Posted / pradeep

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 what is use of dbcc commands?

987

How to download and install sql server 2005 books online?

1083

How to send email from database?

948

Can I work with several databases simultaneously? : sql server management studio

942

What is partition index in sql server?

1046

When do you think a developer should use sql server-based cursors?

975

what is database replication? : Sql server database administration

984

Do you know the capabilities of cursors?

1074

what are the different ways to return the rowcount of a table?

942

What is a transactions?

970

Explain encryption of entire databases without the need for application changes in sql server 2008?

993

What is db stored procedure?

810

Is BCNF better than 2NF & 3NF? Why?

1002

List the advantages of using stored procedures?

996

What are the restrictions that views have to follow? : SQL Server Architecture

944