Home » RDBMS Server » Performance Tuning » Optimizer=Choose Error
Optimizer=Choose Error [message #134716] Fri, 26 August 2005 06:58
Scott Cowan
Messages: 15
Registered: February 2004
Junior Member
I've got a query that uses DBMS_XMLQUERY to generate an XML resultset. If we set the optimizer_mode=choose , then no rows are returned , if we set optimizer_mode=rule, then we get data.

If set a trace , prior to optimizer_mode=choose , then we get data back .

Scott
Previous Topic: How test performance of table? and how to calucalate row size min and max of the Table
Next Topic: slow DB server
Goto Forum:
  


Current Time: Fri Mar 29 01:49:49 CDT 2024