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
sn2710
Messages: 1
Registered: February 2008
Junior Member
Hello,
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: 64152
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.

Quote:
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.

Regards
Michel


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


Current Time: Sun Dec 11 00:23:15 CST 2016

Total time taken to generate the page: 0.08365 seconds