Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: Perofrmance Problem -

    We are facing some strange performance problems recently. ONE SQL Query was working fine and there observed a performance problem, When we set parameter optimizer_index_cost_adj=10, plan looks better (similar to what it was earlier).

    Attaching herewith Plans taken with and without setting optimizer_index_cost_adj.

    Any suggestion is highly appreciated.
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2004
    Posts
    99
    when was the table last analyzed? why dont you try analyzing the table and compare explain plans! to see the impact.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    I suggest fixing the merge join cartesian if possible.

    then attach a new plan.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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