Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "Chuck" <chuck.carson@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Ugh, sluggish query
Date: 8 Aug 2005 06:15:09 -0700
Organization: http://groups.google.com
Lines: 13
Message-ID: <1123506909.034038.219700@g14g2000cwa.googlegroups.com>
References: <1123266423.610971.112330@z14g2000cwz.googlegroups.com>
   <rbd7f11vbckircbqsel77pm3vjjggakhqb@4ax.com>
   <1123275018.471439.72740@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 148.87.1.171
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1123506914 5436 127.0.0.1 (8 Aug 2005 13:15:14 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 8 Aug 2005 13:15:14 +0000 (UTC)
In-Reply-To: <1123275018.471439.72740@o13g2000cwo.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=148.87.1.171;
   posting-account=qPhBSg0AAADvCN1Uo3oydVX8Z6L9Xz2B
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:249094

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