Re: Is this SQL transformation possible...?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 18 Oct 2006 20:03:12 +0100
Message-ID: <45367A70.6090801@dial.pipex.com>

mccmx_at_hotmail.com wrote:
> Oracle 10.2.0.2 on Windows 2003
>
> Is it possible for Oracle to transform the following SQL so that it can
> drive off an index on ST_INSTANCE on PS_TL_RPTD_TIME...?

I suspect that it is possible, though I haven't rewritten as a join which I understand better.

however you can answer the question by getting a 10053 trace of what decisions the optimizer has taken. I suspect, but don't know, that the path you want either costs too much or has been eliminated for some other reason.

-- 

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/

Received on Wed Oct 18 2006 - 14:03:12 CDT