Home » RDBMS Server » Performance Tuning » Has anyone ever seen BEGIN_OUTLINE_DATA alone change a plan (11.2.0.4)
Has anyone ever seen BEGIN_OUTLINE_DATA alone change a plan [message #629263] Fri, 05 December 2014 02:55
Roachcoach
Messages: 1571
Registered: May 2010
Location: UK
Senior Member
Morning all.

Just a quick question.

Per title, adding /*+ BEGIN_OUTLINE_DATA */ will change a plan on a DB I have.

Now I've eliminated the possibility of it being a reparse.

The short version of how I got here was selectively removing hints from the full outline to discover which one was causing the plan I wanted to happen.

Except I could remove everything execpt the above?


Anyone seen this before? My gut says bug.
Previous Topic: Effective way to update a column to null (based on a condition) quickly in a huge 800 GB table
Next Topic: performance issue with sql query in UAT, But good in local
Goto Forum:
  


Current Time: Wed Nov 21 10:45:06 CST 2018