Re: Ugh, sluggish query

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Mon, 8 Aug 2005 19:34:59 +0200
Message-ID: <42f797c4$0$10955$ba620e4c@news.skynet.be>

"Chuck" <chuck.carson_at_gmail.com> wrote in message news:1123506909.034038.219700_at_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
>

Did you compute the table and index statistics after the creation of the index ? Received on Mon Aug 08 2005 - 12:34:59 CDT