Re: What index access path does INDEX

From: Spendius <spendius_at_muchomail.com>
Date: 31 Dec 2006 03:18:24 -0800
Message-ID: <1167563904.416245.84940@v33g2000cwv.googlegroups.com>

Forgot to add the following lines from a 10053 trace:

SINGLE TABLE ACCESS PATH
  Column (#2): ID(NUMBER)
    AvgLen: 5.00 NDV: 228728 Nulls: 0 Density: 4.3720e-06 Min: -1 Max: 5766027
  Table: TABLE_1 Alias: TF
    Card: Original: 12956500 Rounded: 57 Computed: 56.65 Non Adjusted: 56.65
  Access Path: TableScan
    Cost: 29085.35 Resp: 29085.35 Degree: 0

      Cost_io: 28450.00  Cost_cpu: 5144333483
      Resp_io: 28450.00  Resp_cpu: 5144333483
kkofmx: index filter:"TF"."ID"=5485186
                 AND "TF"."OTHE_ID"="TT"."OTHE_ID"
                 AND "OT"."DSCR"="TT"."DSCR"

  Access Path: index (skip-scan)
    SS sel: 4.3720e-06 ANDV (#skips): 4378945     SS io: 4378945.00 vs. table scan io: 28450.00     Skip Scan rejected
  Access Path: index (FullScan)
    Index: TABLE_1_PK
    resc_io: 48164.00 resc_cpu: 3060392722     ix_sel: 1 ix_sel_with_filters: 4.3720e-06     Cost: 48621.98 Resp: 48621.98 Degree: 1   Best:: AccessPath: TableScan

Cost: 29085.35 Degree: 1 Resp: 29085.35 Card: 56.65 Bytes: 0

Received on Sun Dec 31 2006 - 05:18:24 CST

Re: What index access path does INDEX_SS yield ?