Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: composite index

Re: composite index

From: Doron <doron_almog_at_msn.com>
Date: 11 Dec 2003 13:43:04 -0800
Message-ID: <995517bc.0312111343.259fa74d@posting.google.com>


you could if you use a hint to force use of the Index and see if it saves you time

select /*+ index(index_name) */ *
from .....
where ....

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1071154705.558544_at_yasure>...
> Laly wrote:
> > Hello,
> >
> >
> > Suppose we have a huge table T(a, b, ...)
> > There is a primary key on (a, b).
> > Can we gain some time on queries like
> > select *
> > from T
> > where a = ...
> > by creating a new nonunique index on column a.
> >
> >
> > Thanks in advance,
> >
> >
> > Laly.
>
> Version number?
>
> Possibly. It is worth testing in a specific situation.
>
> Certainly one on 'b' would be more likely to generate an improvement
> provided the cost of the indexes maintenance isn't larger than the
> improvement.
>
> There is no general rule other than try it and find out.
Received on Thu Dec 11 2003 - 15:43:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US