Re: PUSH_SUBQ when via ADO ?

From: Richard Shea <richardshea_at_fastmail.fm>
Date: 11 Apr 2003 03:52:22 -0700
Message-ID: <282f826a.0304102330.2bb6ab1@posting.google.com>

Noons <wizofoz2k_at_yahoo.com.au.nospam> wrote in message news:<Xns9357EF8C1333DTokenthis_at_210.49.20.254>...
> Following up on Richard Shea, 08 Apr 2003:
>
> >
> > Is there something about ADO (or msdaora) that means the hint would be
> > ignored ?
> >

Thanks to both of you for your suggestions and sorry I haven't got back sooner - today has been the first day I could look at this again. In fact when I went to look at it again I realised that I had made a very simple mistake in the ASP code but not in the SQLPlus and that's what was causing the problem.

What was the mistake ? Well I had ...

SELECT * /*+ PUSH_SUBQ */ FROM T ...instead of ...

SELECT /*+ PUSH_SUBQ */ * FROM T ... as soon as I fixed that everything was fine !

Thanks again for your help.

regards

richard shea. Received on Fri Apr 11 2003 - 05:52:22 CDT