Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Ugh, sluggish query

Re: Ugh, sluggish query

From: Chuck <chuck.carson_at_gmail.com>
Date: 8 Aug 2005 06:15:09 -0700
Message-ID: <1123506909.034038.219700@g14g2000cwa.googlegroups.com> 





I created an index as follows:



CREATE INDEX "DM"."BU_NOTIFY_DATE_INDEX"

    ON "DM"."BU_NOTIFY"  ("BU_DATE")



    TABLESPACE "DM_INDEX" PCTFREE 10 INITRANS 2 MAXTRANS 255

    STORAGE ( INITIAL 64K NEXT 0K MINEXTENTS 1 MAXEXTENTS

    2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)

    LOGGING REVERSE


However query performance didn't improve. Is this index correct for my
particuliar scenario?


Thx
Received on Mon Aug 08 2005 - 08:15:09 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US