aspose file tools
The moose likes Oracle/OAS and the fly likes indexing Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Groovy Fundamentals video training course this week in the Groovy forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "indexing" Watch "indexing" New topic
Author

indexing

vijayakumar durai
Ranch Hand

Joined: Aug 18, 2008
Posts: 153
can any body tell about the indexing .what is the advantage of using indexing?
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32088
    
207

Indexing is a way of getting to data faster. Just like in a book. If you are trying to find the page that "exporting" is discussed, do you read the entire book or look at the index in the back to find the specific page? Which is faster?

It works the same way for a database. The index helps Oracle find the specific page in memory containing the requested data without looking through the whole table.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
wood burning stoves
 
subject: indexing