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

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5410


Can a parameter be passed to a cursor?

1126


What are the general rules on data consistency?

1009


How remove data files before opening a database?

1074


Explain cascading triggers.

1074


Describe the types of sub query?

999


What is different types of joins?

1022


Which is better Oracle or MS SQL? Why?

6388


How to empty your oracle recycle bin?

1021


Explain about integrity constraint?

1124


What is the oracle implicit cursor?

1063


Write a trigger example in oracle?

1065


What are the benefits of ordbms?

1088


What is oracle database client?

1032


How to export data to a csv file?

1306