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

Home -> Community -> Mailing Lists -> Oracle-L -> bitmap conversion to rowids operation with btree indexes?

bitmap conversion to rowids operation with btree indexes?

From: <ryan_gaffuri_at_comcast.net>
Date: Tue, 11 Jan 2005 15:54:50 +0000
Message-Id: <011120051554.23109.41E3F6CA00038D9200005A452200735446079D9A00000E09A1020E979D@comcast.net> 





I see this operation in plans occasionally when I'm using btree indexes and there are not any bitmaps. I also see:
BITMAP OR


when using 2 btree indexes in the plan. 



does oracle do some conversion to bits to optimize certain plans even without bitmap indexes? 


--
http://www.freelists.org/webpage/oracle-l


Received on Tue Jan 11 2005 - 09:56:53 CST












Original text of this message













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