This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android forum!
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
internet detective

Joined: May 26, 2003
Posts: 30136

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:
subject: indexing
Similar Threads
Find the previous element in a List
Indexing Software
Head First SQL : indexing and views