Index Design

From: Jennifer <jennifer_watson_at_yahoo.com>
Date: 9 Sep 2005 08:58:24 -0700
Message-ID: <1126281504.719473.197170@f14g2000cwb.googlegroups.com>

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 Received on Fri Sep 09 2005 - 10:58:24 CDT