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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx 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 > > > > > > -- > //www.freelists.org/webpage/oracle-l > > -- //www.freelists.org/webpage/oracle-l