Home » SQL & PL/SQL » SQL & PL/SQL » Indexes
Indexes [message #37410] Wed, 06 February 2002 08:12 Go to next message
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 Go to previous message
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.
Previous Topic: Quotation Marks in SQL output
Next Topic: How to choose duplicate records (tuples)?
Goto Forum:
  


Current Time: Mon Sep 27 17:56:15 CDT 2021