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 indexing, and how does it improve performance?

Answer Posted / hr@tgksolutions.com

Indexing creates a data structure that speeds up data retrieval operations. It reduces the number of disk accesses required for queries. However, too many indexes can slow down INSERT, UPDATE, and DELETE operations.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain an extent?

1053


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2214


In which language oracle has been developed?

1026


What is procedure overloading in oracle?

1003


Explain about functional dependency and its relation with table design?

966


Will you be able to store pictures in the database?

1075


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2270


How to add a new column to an existing table with a default value?

983


can anyody please send me the dump for Oracle 10g certifications for DBA path?

2097


What is oracle database 10g express edition?

1082


What is the difference between a primary key & a unique key?

1049


What is merge statement used for?

981


What is the difference between pre-select and pre-query?

1143


How to export several tables together?

1000


What is bulk load in oracle?

1017