RE: Export - can I use a hint or set a session level value?

Correction. It should be "rowid in" instead of "rowid ="

query=\"WHERE rowid in \(select \/\*\+ PUT_YOUR_HINT_HERE \*\/rowid from email_request_queue\)\" Oracle accepts rowid with subquery is accepted.

HTH
GovindanK

On Fri, 26 May 2006 16:08:12 -0700, "GovindanK" <gkatteri_at_fastmail.fm> said:
> Give this a try. Another theoritcal possibility.
>
> exp ... query=(where rowid=(select /*+ hint */ rowid from table where
> ..condition..) )
> This should make the horizontal filtering of rows process faster.
>
> HTH
> GovindanK
>
> On Fri, 26 May 2006 18:45:35 -0400, JayMiller_at_TDWaterhouse.com said:
> > I'm not clear on what you tried? This looks like my original export
> > script which is giving me the bad access path (without the index).
> >
> > My question was how to add a hint or some other method to force use of
> > the index as the for some profiles the script is now taking over an hour
> > instead of 5 minutes.
> >
> > Thanks,
> > Jay Miller
> > Sr. Oracle DBA
> > x68355
> >
> >
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l