Re: Partition Views - Help wanted

From: Nick Butcher <nickb_at_btinternet.com>
Date: 1997/07/29
Message-ID: <01bc9c76$1727f5a0$63f20082@otis>#1/1

I can't see how to make this work with Partition Views as the target index has a different name in each partition, e.g. cust_index_1996, cust_index_1997 etc. So you can't tell the optimizer which index to use.  

---

Nick Butcher
nickb_at_btinternet.com

Tomm Carr <tommcatt_at_geocities.com> wrote in article <33DD65FA.164C_at_geocities.com>...
> Nick Butcher wrote:
> >
> > I am looking for help implementing partition views in Oracle 7.3. I am
> > particularly interested in indexing strategies. Having run EXPLAIN PLAN
 on
> > a number of statements, the Optimizer doesn't seem to use the indexes I
> > would have thought appropriate. If anybody knows of any good
> > books/papers/sources of information, I would appreciate their help.
>
> If the optimizer is using one index and you know that a different index
> would be better, you may override the optimizer's choice with a *hint*.
> For example:
>
> select /*+ index(tablename, indexname) */ col1, col2, ...
> from tablename
> where ...
>
> Try that.
>
> --
> Tomm Carr
> --
> "Can you describe your assailant?"
> "No problem, Officer. That's exactly what I was doing when he hit me!"
>
Received on Tue Jul 29 1997 - 00:00:00 CDT