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 does the update command do?

1112


Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1051


What is the definition for sql server 2000?

1088


What are two difference between sql azure and azure tables?

159


What is user-defined function?

970


What are the main differences between #temp tables and @table variables and which one is preferred?

1083


How to find tables without indexes?

1088


Explain the steps to create and execute a user-defined function in the sql server?

967


What is scalar user-defined function?

1100


How to manipulate data from one table to another table ?

969


Describe different Processing Modes offered by SSRS?

248


How many database files are there in sql server 2000?what are they?

1051


What is query parameter in ssrs?

160


You are doing log shipping due to some reasons it is failing. How you will proceed from there

2069


How fixed length strings are truncated and padded?

980