Re: Query optimization

From: joel garry <>
Date: Fri, 10 Jan 2014 15:46:38 -0800 (PST)
Message-ID: <>

[Quoted] On Friday, January 10, 2014 9:03:50 AM UTC-8, Mark wrote:

> Version is
> >Also, please report how you determined that the indexes are not being used; you posted no execution plans to prove your assertion.
> I was told this by the DBA. I don't know how to do this with Oracle. I
> usually work with Ingres.

There are several ways. The simplest is if you have dbconsole, you can just drill into it and see the plan. Randolf came up with a procedure for asking about performance problems on OTN:

Jonathan Lewis has written books on the optimizer and core internals if you really want to be pro about it.


-- is bogus.
Received on Sat Jan 11 2014 - 00:46:38 CET

Original text of this message