| Indexes [message #37410] |
Wed, 06 February 2002 08:12  |
sverch
Messages: 582
Registered: December 2000
|
Senior Member |
|
|
Hi,
If my Execution Plan tells me: TABLE ACCESS (BY INDEX ROWID)
does it mean that Oracle ignores my indexes and only uses Oracle generated ROWID?
Thank you
|
|
|
|
| Re: Indexes [message #37412 is a reply to message #37410] |
Wed, 06 February 2002 10:17  |
Todd
Messages: 17
Registered: October 2000
|
Junior Member |
|
|
|
No, it is not ignoring your index. It is using the rowid stored in the index to locate the table row.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
