File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "indexing" Watch "indexing" New topic


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

Joined: May 26, 2003
Posts: 33107

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]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: indexing
It's not a secret anymore!