From oracle-l-bounce@freelists.org Tue Jan 11 09:56:53 2005 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id j0BFuiE22315 for ; Tue, 11 Jan 2005 09:56:45 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id j0BFufn22308 for ; Tue, 11 Jan 2005 09:56:41 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6F15172CB67; Tue, 11 Jan 2005 11:00:22 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15843-42; Tue, 11 Jan 2005 11:00:22 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A967672D5EE; Tue, 11 Jan 2005 10:59:05 -0500 (EST) From: ryan_gaffuri@comcast.net To: oracle-l@freelists.org Subject: bitmap conversion to rowids operation with btree indexes? Date: Tue, 11 Jan 2005 15:54:50 +0000 Message-Id: <011120051554.23109.41E3F6CA00038D9200005A452200735446079D9A00000E09A1020E979D@comcast.net> X-Authenticated-Sender: cnlhbl9nYWZmdXJpQGNvbWNhc3QubmV0 MIME-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 14607 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan_gaffuri@comcast.net Precedence: normal Reply-To: ryan_gaffuri@comcast.net X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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