Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "Jennifer" <jennifer_watson@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Index Design
Date: 9 Sep 2005 08:58:24 -0700
Organization: http://groups.google.com
Lines: 20
Message-ID: <1126281504.719473.197170@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 57.68.33.197
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126281509 13348 127.0.0.1 (9 Sep 2005 15:58:29 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 9 Sep 2005 15:58:29 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=57.68.33.197;
   posting-account=DLsg5A0AAACJlbdC2jp7udlZHZYxCI29
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251176

What is a good documentation resource for index designing?  We're
running oracle 10g, and I have a number of queries that need to run
similar to the below example:

FROM   "BILL_FCT"  AB
JOIN DATE_DIM DD
ON AB.DATE_SKEY  = DD.DATE_SKEY
JOIN RE_DIM RD
ON AB.RE_SKEY = RD.RE_SKEY
join FP_DIM FP
ON AB.FP_SKEY = FP.FP_SKEY
WHERE RD.PH_SKEY = 27
AND SUBSTR(FINANCIAL_PLAN_CODE, 1,2) NOT IN ('MB','XX')

I can create a column that can bypass the substr if needed.

Thanks!

Jennifer