Re: index skip scan

From: jernigam_at_nospam.kochind.com <jernigam_at_kochind.com>
Date: Tue, 6 Jan 2009 11:15:49 -0800 (PST)
Message-ID: <a86eadb8-4508-48c2-93a2-792aaa0e1d1f_at_v4g2000vbb.googlegroups.com>

SINGLE TABLE ACCESS PATH
  Column (#10): EFFECTIVE_DATE(DATE)
    AvgLen: 8.00 NDV: 4022 Nulls: 0 Density: 2.4863e-04 Min: 2448989 Max: 2456294
  Table: INVENTORY_TRANS_QTY Alias: ITQ     Card: Original: 13991744 Rounded: 11140 Computed: 11140.26 Non Adjusted: 11140.26
  Access Path: TableScan
    Cost: 45303.76 Resp: 45303.76 Degree: 0

      Cost_io: 39022.00  Cost_cpu: 7870260780
      Resp_io: 39022.00  Resp_cpu: 7870260780

kkofmx: index filter:"ITQ"."EFFECTIVE_DATE">=TO_DATE('2008-12-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "ITQ"."EFFECTIVE_DATE"<TO_DATE
('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE"<TO_DATE('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE">=TO_DATE('2008-12-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "ITQ"."EFFECTIVE_DATE"<TO_DATE
('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE"<TO_DATE('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE">=TO_DATE('2008-12-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "ITQ"."EFFECTIVE_DATE"<TO_DATE
('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE"<TO_DATE('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE">=TO_DATE('2008-12-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "ITQ"."EFFECTIVE_DATE"<TO_DATE
('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE"<TO_DATE('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE">=TO_DATE('2008-12-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "ITQ"."EFFECTIVE_DATE"<TO_DATE
('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE"<TO_DATE('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE">=TO_DATE('2008-12-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "ITQ"."EFFECTIVE_DATE"<TO_DATE
('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
kkofmx: index filter:"ITQ"."EFFECTIVE_DATE"<TO_DATE('2008-12-05 00:00:00', 'yyyy-mm-dd hh24:mi:ss')
  Access Path: index (skip-scan)
    SS sel: 1.6282e-04 ANDV (#skips): 3011     SS io: 3011.00 vs. table scan io: 39022.00     Skip Scan chosen
  Access Path: index (SkipScan)
    Index: INV_TRANS_QTY_IND11
    resc_io: 3451.00 resc_cpu: 27258899     ix_sel: 1.6282e-04 ix_sel_with_filters: 1.6282e-04     Cost: 1736.38 Resp: 1736.38 Degree: 1   Access Path: index (skip-scan)
    SS sel: 1.6282e-04 ANDV (#skips): 74232     SS io: 74232.00 vs. table scan io: 39022.00     Skip Scan rejected
  Access Path: index (FullScan)
    Index: INV_TRANS_QTY_IND12
    resc_io: 51941.00 resc_cpu: 3175230135     ix_sel: 1 ix_sel_with_filters: 7.9620e-04     Cost: 27573.96 Resp: 27573.96 Degree: 1   Access Path: index (RangeScan)
    Index: INV_TRANS_QTY_IND2
    resc_io: 1435.00 resc_cpu: 23193396     ix_sel: 7.9620e-04 ix_sel_with_filters: 7.9620e-04     Cost: 726.76 Resp: 726.76 Degree: 1   Access Path: index (skip-scan)
    SS sel: 1.6282e-04 ANDV (#skips): 560     SS io: 560.00 vs. table scan io: 39022.00     Skip Scan chosen
  Access Path: index (SkipScan)
    Index: INV_TRANS_QTY_IND3
    resc_io: 987.00 resc_cpu: 9550211
    ix_sel: 1.6282e-04 ix_sel_with_filters: 1.6282e-04     Cost: 497.31 Resp: 497.31 Degree: 1   Access Path: index (skip-scan)
    SS sel: 1.6282e-04 ANDV (#skips): 660     SS io: 660.00 vs. table scan io: 39022.00     Skip Scan chosen
  Access Path: index (SkipScan)
    Index: INV_TRANS_QTY_IND5
    resc_io: 1402.00 resc_cpu: 12512629     ix_sel: 1.6282e-04 ix_sel_with_filters: 1.6282e-04     Cost: 705.99 Resp: 705.99 Degree: 1   Access Path: index (skip-scan)
    SS sel: 1.6282e-04 ANDV (#skips): 744     SS io: 744.00 vs. table scan io: 39022.00     Skip Scan chosen
  Access Path: index (SkipScan)
    Index: INV_TRANS_QTY_IND7
    resc_io: 1481.00 resc_cpu: 13028423     ix_sel: 1.6282e-04 ix_sel_with_filters: 1.6282e-04     Cost: 745.70 Resp: 745.70 Degree: 1   Access Path: index (skip-scan)
    SS sel: 1.6282e-04 ANDV (#skips): 3011     SS io: 3011.00 vs. table scan io: 39022.00     Skip Scan chosen
  Access Path: index (SkipScan)
    Index: INV_TRANS_QTY_IND9
    resc_io: 3516.00 resc_cpu: 27780293     ix_sel: 1.6282e-04 ix_sel_with_filters: 1.6282e-04     Cost: 1769.09 Resp: 1769.09 Degree: 1

trying bitmap/domain indexes ****** Best:: AccessPath: IndexRange Index: INV_TRANS_QTY_IND3 Cost: 497.31 Degree: 1 Resp: 497.31 Card: 11140.26 Bytes: 0

Received on Tue Jan 06 2009 - 13:15:49 CST

This message: [ Message body ]
Next message: Palooka: "Re: how to link BBED executable in windows"
Previous message: jernigam_at_nospam.kochind.com: "Re: index skip scan"
Maybe in reply to: jernigam_at_nospam.kochind.com: "index skip scan"
Next in thread: jernigam_at_nospam.kochind.com: "Re: index skip scan"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message