Re: O9i: How to create a matching index to a given query

On Apr 3, 10:29 am, Andreas Mosmann <mosm..._at_expires-30-04-2007.news- group.org> wrote:
> sybra..._at_hccnet.nl schrieb am 02.04.2007 in
> <met2135m7p791c87nhfm0chkun8juq1..._at_4ax.com>:
>
> > In the second case you select a non-indexed column. Apparently the
> > optimizer predicts this will take less I/O. This would be a case for
> > to set event 10051.
>
> Can you point me to a place in the Oracle documentation where I can read
> about the HowTo?
> - I looked for event and there were too many results.
> - I looked for 10051 and there were no result.
>
> a better keyword than these 2 might also help a lot.
>
> > Hth
>
> Me too ;)
>
> Many thanks
>
> Andreas Mosmann
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de

General instructions to manipulate events in doc 75713.1 at Metalink. Also read doc 218105.1
There were documents on 10051 previously. I believe Jonathan Lewis also discusses it in his CBO book, but I don't have this handy at the moment.

Hth

--
Sybrand Bakker
Senior Oracle DBA