It appears that DBMS_SQL is not using an optimizer hint provided in a SQL
Statement...The syntax I'm using is as follows:
*/
can run this statement in PL/SQL and get a 1-2 second response time.
same statement, when Parsed and executed in DBMS_SQL returns
response time. I have tried several things, such as using
with the Index, the CHOOSE hint, as well as
specified but the response time in
seconds with PL/SQL at 1 to 2
with DBMS_SQL? We are running
statistics are up to date, and I believe
optimization.
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Jul 29 1998 - 09:02:01 CDT
