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 are indexes? When do you need to create Indexes?

Answer Posted / bhagwat sharma

When data volumes increase, organizations are faced with
problems relating to data retrieval and posting. They feel
the need for a mechanism that will increase the speed of
data access. An index, like the index of a book, enables the
database retrieve and present data to the end user with
ease. An index can be defined as a mechanism for providing
fast access to table rows and for enforcing constraints.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is 'write-ahead log' in sql server 2000 ?

991


What is xdr?

930


what is a traditional network library for sql servers? : Sql server database administration

894


What are cascading parameters in ssrs reports?

212


Explain the steps to use transact-sql cursor?

961


Why normalization is used?

967


Explain candidate key, alternate key, and composite key?

942


Explain what is dbcc?

964


Mention the uses of stored procedures.

928


What is the use of “join” in sql server?

1020


What to check if a User database is locked?

1021


How to write a query with a right outer join in ms sql server?

873


you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

992


How can I create a report based on a query? : sql server management studio

976


Do you know how to store and query spatial data?

984