Thread: [INSTRUCTIONS] Default Settings for New OTM DB
View Single Post
  #2 (permalink)  
Old August 20th, 2008, 12:39
Kristof Stevens Kristof Stevens is offline
Junior Member
  
Join Date: May 2007
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
Kristof Stevens is on a distinguished road
Re: [INSTRUCTIONS] Default Settings for New OTM DB
Currently we are using optimize Mode CHOOSE in OTM, but it seems the CHOOSE mode is desupported with Oracle 10g.
I created a new index on a high cost SQL and compared the optimize mode CHOOSE with FIRST_ROWS_10 or _100.Even with the nex index creation and with CHOOSE the SQL results in a table access full scan, costs 50984
When I changed into FIRST_ROWS_10 or 100, cost 72.

The cost reduced from 50984 to 72...Couldn't we consider to change our optimize mode from CHOOSE into FIRST_ROWS_10? What will be the impact into OTM?

If we are going to change database mode to first_rows, then there is maybe need to change mode with "alter session" to all_rows when running reports or big batch jobs.

Thx,

Kristof.
Reply With Quote