PUSH_SUBQ when via ADO ?

From: Richard Shea <richardshea_at_fastmail.fm>
Date: 8 Apr 2003 03:40:02 -0700
Message-ID: <282f826a.0304080240.400f63cf@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 - 05:40:02 CDT