Re: 10053 shows bitmap index not being used

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Wed, 25 Oct 2006 12:36:42 +0200
Message-ID: <486b2b610610250336p4f274745ncc5420d88697f261@mail.gmail.com>

Ah sorry. I figured all the info *should* be in that part of the tracefile :)

Index stats
  Index: MKER_F_DECKUNGSBEITRAG_BMIDX COL#: 12     TOTAL :: LVLS: 2 #LB: 1268 #DK: 24 LB/K: 52 DB/K: 105 CLUF: 2537   Index: MKER_F_DECKUNGSBEITRAG_IDX_00 COL#: 12 2 3 4 13     TOTAL :: LVLS: 3 #LB: 400400 #DK: 48862900 LB/K: 1 DB/K: 1 CLUF: 38428900
  Index: MKER_F_DECKUNGSBEITRAG_IDX_01 COL#: 12 1     TOTAL :: LVLS: 3 #LB: 162736 #DK: 48657778 LB/K: 1 DB/K: 1 CLUF: 1093305
  Index: MKER_F_DECKUNGSBEITRAG_PK COL#: 1     TOTAL :: LVLS: 2 #LB: 101300 #DK: 46405900 LB/K: 1 DB/K: 1 CLUF: 1141833

Bitmap Index is on DBE_MTH col.

SELECT T_DEB.T008_ITN_IDN_CDE
, T_DEB.T130_ACT_RFE_NBR_TXT_TOP
, SUM(T_DEB.DBE_AMT_ROL) AS DBE_AMT_ROL FROM MKER_F_DECKUNGSBEITRAG T_DEB
WHERE T_DEB.DBE_MTH = (SELECT brt_mth

           FROM MKER_S_BATCH_RT
      WHERE BRT_STS = 'RUNNING'
      AND   BRT_NAM = 'KER')

GROUP BY T_DEB.T008_ITN_IDN_CDE, T_DEB.T130_ACT_RFE_NBR_TXT_TOP Plan Table

| Operation                      | Name               | Rows  | Bytes |
Cost  | Time      |  TQ  |IN-OUT| PQ Distrib |Pstart| Pstop |


-------------------------------------------------------------------------------------------------------------------------------------

| SELECT STATEMENT               |                    |       |       |
64K |           |      |      |           |       |       |
|  SORT GROUP BY                 |                    |  775K |   23M |
64K |  00:04:52 |      |      |           |       |       |
|   TABLE ACCESS BY INDEX ROWID  | MKER_F_DECKUNGSBEITRAG| 2032K |   60M |
52K |  00:03:09 |      |      |           |       |       |
|    INDEX RANGE SCAN            | MKER_F_DECKUNGSBEITRAG_IDX_01| 2032K
|       |  6984 |  00:00:25 |      |      |           |       |       |
|     TABLE ACCESS FULL          | MKER_S_BATCH_RT    |     1 |    16 |
2 |  00:00:01 |      |      |           |       |       |


-------------------------------------------------------------------------------------------------------------------------------------

On 10/25/06, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:

>
> the sql and the index structure might be of some help as well :(
>
> On 10/25/06, Stefan Knecht <knecht.stefan_at_gmail.com > wrote:
> >
> >
> > What could be the reason ?  Would appreciate someone shedding some light
> > on this :)
> >
> > Stefan
> >
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

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

Received on Wed Oct 25 2006 - 05:36:42 CDT

Re: 10053 shows bitmap index not being used - why ?