Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PUSH_SUBQ when via ADO ?
Find out what's happening under the hood.
use ODBC trace at the client, and use SQL_TRACE at the server to see exactly
what is being executed by Oracle.
"Richard Shea" <richardshea_at_fastmail.fm> wrote in message
news:282f826a.0304080240.400f63cf_at_posting.google.com...
> Hi - I've got a query that benefits from the /*+ PUSH_SUBQ */ hint.
> I've been testing this in SQLPLUS but I really want to use the query
> in an ASP page via ADO (the msdaora driver to be specific).
>
> The hint really makes a big difference when used in SQLPLUS (changes
> duration of query from approx 15 seconds to less than 1 second).
> However when used via ADO the query appears to be taking as long as it
> would in SQLPLUS without the hint.
>
> Is there something about ADO (or msdaora) that means the hint would be
> ignored ?
>
> (Just to be clear when I say I'm using ADO I'm referring to the
> EXECUTE method of the connection object using normal SQL,eg ...
>
> myconn.execute("select * from t")
>
> ... I'm not talking about any form of querying which may exist as a
> method of an ADO object).
>
>
> thanks
>
> richard shea.
Received on Tue Apr 08 2003 - 08:16:08 CDT