This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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: 32635
    
215

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: http://aspose.com/file-tools
 
subject: indexing
 
It's not a secret anymore!