File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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: 30749
    
156

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.


[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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: indexing