Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can Explain detect bitmap index?

Can Explain detect bitmap index?

From: <pcucciolo_at_hotmail.com>
Date: Mon, 07 Dec 1998 11:16:35 GMT
Message-ID: <74gdei$92k$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US