Home » SQL & PL/SQL » SQL & PL/SQL » data access path in oracle (oracle 8i)
data access path in oracle [message #299042] Fri, 08 February 2008 13:07 Go to next message
Messages: 1
Registered: February 2008
Junior Member
what do u mean by data access path in oracle?
what does this statement mean?
"Data access paths are implemented in Oracle using indexes. Indexinghelps to predefine the most common access paths for querying the database.
These indexes decrease the time it takes to search for data in a table by using
a number of data structures, such as B-trees, bitmaps, and so on"
Re: data access path in oracle [message #299048 is a reply to message #299042] Fri, 08 February 2008 13:15 Go to previous message
Michel Cadot
Messages: 63915
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First don't use IM speak.
Have a look at OraFAQ Forum Guide, there is a section about this.

what do u mean by data access path in oracle?

The way Oracle use to access the data: full table scan, index range scan, access by rowid...

The sentence is not entirely true. Access path may not involved any index.
When you quote something you MUST say from what you quote and if possible post an url.


Previous Topic: cursor
Next Topic: Sql query using Sum function and Having clause
Goto Forum:

Current Time: Mon Oct 24 11:54:54 CDT 2016

Total time taken to generate the page: 0.10773 seconds