Results 1 to 2 of 2

Thread: Features of Oracle optimizer

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    71

    Features of Oracle optimizer

    What are the features of Oracle optimizer? Does this optimize SQL queries only or is it used for any other purpose also.


  2. #2
    Contributing Member
    Join Date
    May 2006
    Answers
    82

    Re: Features of Oracle optimizer

    The oracle optimizer operates on two purposes namely
    Cost Based
    Rule Based
    Setting the oracle optimizer to RULE will make the rule-based optimizer function in such a way by which execution paths, rules are evaluated to find out alternating best path and so on. Setting the oracle optimizer to CHOOSE will make it function the cost-based optimizer by which statistics of objects in database like number of rows, keys and so on are evaluated which helps to know about the cost.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact