Re: Partition Views - Help wanted

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!"