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