Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 15255 invoked from network); 18 Dec 2007 13:37:13 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 18 Dec 2007 13:37:11 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BAACD7DB2C0; Tue, 18 Dec 2007 14:37:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10158-03; Tue, 18 Dec 2007 14:37:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 084CE7DB2F3; Tue, 18 Dec 2007 14:37:07 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 18 Dec 2007 13:49:43 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 69FB67DA27C for ; Tue, 18 Dec 2007 13:49:43 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 04052-05 for ; Tue, 18 Dec 2007 13:49:43 -0500 (EST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.229]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66F017DA25C for ; Tue, 18 Dec 2007 13:49:35 -0500 (EST) Received: by nz-out-0506.google.com with SMTP id s18so1340096nze.1 for ; Tue, 18 Dec 2007 10:49:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=Zz0PmFHTzc97ninW4iqEHCqKPTi+eO/iIsEGv3l7rMc=; b=ak2aVxcyOtpiW/2OpJE9vmz6679FPtGPOnaNO+YJIfbQ7mT5XG9e1ROHKSKPN4VgzeUBZWMmrFTb8QavBMhefARUIMnRU75fLqe7fZeirua1TgbBGeqy43PyXWCdwgO05Fs5roM9kFxAYJUL3/Ef6vNMX/b+Z1kg8pZdO9DhAOc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=T1FoQ0Kd0qovArbRk/jfvHc1n0t52R3MqtAeXMU0dxKajloNP2/qwsomN7tFx3TBEnx0BvTMcK/LxcdVIHPPlbZ9YhFQVzoJ6UDbdk2sbs+qsdyVCTi5ut3phP2R3UqzMxlAkW5XeEA3FPNwLlfvZKWFMArgX0VO6BOHoxK8zBk= Received: by 10.140.82.40 with SMTP id f40mr2597024rvb.16.1198003768202; Tue, 18 Dec 2007 10:49:28 -0800 (PST) Received: by 10.140.199.11 with HTTP; Tue, 18 Dec 2007 10:49:28 -0800 (PST) Message-ID: <7f411f4e0712181049s3273ba63j9ba51fc9c05717b9@mail.gmail.com> Date: Tue, 18 Dec 2007 13:49:28 -0500 From: "Raj Mareddi" To: oracle-l Subject: Access path: Bitmap index - rejected MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_12448_8461499.1198003768205" X-archive-position: 3997 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: yoursraju007@gmail.com Precedence: normal Reply-to: yoursraju007@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_12448_8461499.1198003768205 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Index: INDEX1 Col#: 1 2 LVLS: 2 #LB: 11825 #DK: 7478026 LB/K: 1.00 DB/K: 1.00 CLUF: 954385.00 Index: INDEX2 Col#: 1 LVLS: 1 #LB: 140 #DK: 1572 LB/K: 1.00 DB/K: 1.00 CLUF: 1655.00 SINGLE TABLE ACCESS PATH Column (#1): NAME (VARCHAR2) AvgLen: 6.00 NDV: 1557 Nulls: 0 Density: 6.4226e-04 Table: TAB1 Alias: TAB1 Card: Original: 7388103 Rounded: 4745 Computed: 4745.09 Non Adjusted: 4745.09 Access Path: TableScan Cost: 27120.03 Resp: 27120.03 Degree: 0 Cost_io: 24677.00 Cost_cpu: 3763177144 Resp_io: 24677.00 Resp_cpu: 3763177144 Access Path: index (RangeScan) Index: INDEX1 resc_io: 623.00 resc_cpu: 21679564 ix_sel: 6.4226e-04 ix_sel_with_filters: 6.4226e-04 Cost: 637.07 Resp: 637.07 Degree: 1 ****** trying bitmap/domain indexes ****** Access Path: index (AllEqRange) Index: INDEX2 resc_io: 1.00 resc_cpu: 10993 ix_sel: 6.4226e-04 ix_sel_with_filters: 6.4226e-04 Cost: 1.01 Resp: 1.01 Degree: 0 Access path: Bitmap index - rejected Cost: 1038.15 Cost_io: 1021.87 Cost_cpu: 25073088 Sel: 6.4226e-04 Not believed to be index-only Best:: AccessPath: IndexRange Index: INDEX1 Cost: 637.07 Degree: 1 Resp: 637.07 Card: 4745.09 Bytes: 0 Why is my bitmap index path rejected ? ------=_Part_12448_8461499.1198003768205 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline   Index: INDEX1 Col#: 1 2
    LVLS: 2  #LB: 11825  #DK: 7478026  LB/K: 1.00  DB/K: 1.00  CLUF: 954385.00
  Index: INDEX2 Col#: 1
    LVLS: 1  #LB: 140    #DK: 1572  LB/K: 1.00  DB/K: 1.00  CLUF: 1655.00

SINGLE TABLE ACCESS PATH
  Column (#1): NAME (VARCHAR2)
    AvgLen: 6.00 NDV: 1557 Nulls: 0 Density: 6.4226e-04
  Table: TAB1  Alias: TAB1
    Card: Original: 7388103  Rounded: 4745  Computed: 4745.09  Non Adjusted: 4745.09
  Access Path: TableScan
    Cost:  27120.03  Resp: 27120.03  Degree: 0
      Cost_io: 24677.00  Cost_cpu: 3763177144
      Resp_io: 24677.00  Resp_cpu: 3763177144
  Access Path: index (RangeScan)
    Index: INDEX1
    resc_io: 623.00  resc_cpu: 21679564
    ix_sel: 6.4226e-04  ix_sel_with_filters: 6.4226e-04
    Cost: 637.07  Resp: 637.07  Degree: 1
  ****** trying bitmap/domain indexes ******
  Access Path: index (AllEqRange)
    Index: INDEX2
    resc_io: 1.00  resc_cpu: 10993
    ix_sel: 6.4226e-04  ix_sel_with_filters: 6.4226e-04
    Cost: 1.01  Resp: 1.01  Degree: 0
  Access path: Bitmap index - rejected
    Cost: 1038.15 Cost_io: 1021.87 Cost_cpu: 25073088 Sel: 6.4226e-04
    Not believed to be index-only
  Best:: AccessPath: IndexRange  Index: INDEX1
         Cost: 637.07  Degree: 1  Resp: 637.07  Card: 4745.09  Bytes: 0

Why is my bitmap index path rejected ?
------=_Part_12448_8461499.1198003768205-- -- http://www.freelists.org/webpage/oracle-l