Re: Dual index question

From: Lewis W Kellum <lwk_at_engin.umich.edu>
Date: 6 Apr 1994 14:18:50 GMT
Message-ID: <2nugcaINNbbo_at_srvr1.engin.umich.edu>


In article <gus.teschke-050494134525_at_no-name-medadmin.med.umich.edu> gus.teschke_at_med.umich.edu (Gus Teschke) writes:
>Hi Woody,
> Which index? It depends. We use the rule-based query builder because
>the cost-based has many bugs. The rule-based builder uses an ordering of
>access paths that enables you to predict how a query plan will be built.
>In your case, the rules say that a composite index will take precedence
>over a single-column index, but I'd use Explain Plan to verify this. In
>the following example (Sun, V7.0.15.4.0), the composite index is not used
>until it is rebuilt as unique.
>
>I haven't found the access path rankings in the V7 manuals, but the V6
>rankings are in the V6 DBA Guide on page 19-17.
> Good
>luck,
>
> Gus
>________________________________________________

THanks, Gus. I will try the vers.6 EXPLAIN on the actual tables I'm working with. We are running Vers. 6 here. I'll RTFM, too.

  • Woody
Received on Wed Apr 06 1994 - 16:18:50 CEST

Original text of this message