DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: No Stats

  1. #1

    Exclamation

    I have removed the STATS so the optimizer always uses RULE based. This is due to queries written in this way.

    What is the impact of having removed Stats, are they only applicable to the Optimizer or are they needed for other processers?
    The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Change the OPTIMIZER_MODE to RULE in init.ora file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width