Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news-lond.gip.net!news.gsl.net!gip.net!news.tele.dk!news.tele.dk!small.news.tele.dk!skynet.be!newspost001!tjb!not-for-mail
Reply-To: "Matthias Hoys" <idmwarpzone_NOSPAM_@yahoo.com>
From: "Matthias Hoys" <idmwarpzone_NOSPAM_@yahoo.com>
Newsgroups: comp.databases.oracle.server
References: <1123266423.610971.112330@z14g2000cwz.googlegroups.com>   <rbd7f11vbckircbqsel77pm3vjjggakhqb@4ax.com>   <1123275018.471439.72740@o13g2000cwo.googlegroups.com> <1123506909.034038.219700@g14g2000cwa.googlegroups.com>
Subject: Re: Ugh, sluggish query
Date: Mon, 8 Aug 2005 19:34:59 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
Lines: 21
Message-ID: <42f797c4$0$10955$ba620e4c@news.skynet.be>
Organization: -= Belgacom Usenet Service =-
NNTP-Posting-Host: 99c32cd7.news.skynet.be
X-Trace: 1123522500 news.skynet.be 10955 81.243.134.179:1125
X-Complaints-To: usenet-abuse@skynet.be
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249114


"Chuck" <chuck.carson@gmail.com> wrote in message 
news: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
>

Did you compute the table and index statistics after the creation of the 
index ?