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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 17:30:57 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.