Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Can Explain detect bitmap index?
I have made a test whit explain on a table indexed by bitmap index. Explain
says: full table scan. Explain in another test whit a classic index on the
same table and same column whit the same query say: scan by row_id. Where is
the true?
Oracle Ver. 8.0.4 on Windows NT.
Thank you.
P.S. Excuse me for my English.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 07 1998 - 05:16:35 CST