Re: Full table scan despite appropriate indexes

From: <aravind.kanda_at_gmail.com>
Date: 7 Feb 2007 14:09:36 -0800
Message-ID: <1170886176.612261.188260@v45g2000cwv.googlegroups.com>

Nope, it did not help. I corrected the syntax as per your suggestion. Here is the index script:

CREATE INDEX MISP.COVSUMM_MONTHSK ON MISP.TCOVERAGES_SUMMARY (MONTH_SK)
NOLOGGING
TABLESPACE MISP
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (

            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )

NOPARALLEL; The query takes about 13 seconds. Received on Wed Feb 07 2007 - 16:09:36 CST