1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Performance tuning Steps

Discussion in 'Oracle Apps Technical' started by jagadekara, Mar 20, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi viewers!

    To increase the performance of any query please keep in mind the following points.

    Steps to Tune the Query :
    ---------------------------------

    • Make sure the proper joins for whatever tables in from clause.
    • Make the joins with "ID's" instead of Database columns.
    • Avoid Multi table views, Use Org Specific views where ever possible.
    • If the custom table is having large amount of create indexes.
    • Avoid Type casting and Aggregate functions,Negation operators on Indexed columns.
    • Instead of using the whole query in a single cursor or group, split into multiple Groups and link them.
    • Use 'union all' instead of Union
    • Use Exists in place of in
    • Avoid usage of Negation operators like NOT, !=.
    • Use Union instead of OR Clause.
    • Avoid Usage of outer joins , use Equi joins where ever possible
    • Use Where Clause instead of Having Clause.
     
  2. neeraja

    neeraja Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    i am facing performance issue there are not reasons in my report
     
  3. neeraja

    neeraja Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    i am facing problem with wf_notifications table to fetch the first approver of iexpense/invoice

    without using wf_notifications table how to fetch the first approver of iexpense /invoice.even if i use the same logic to fetch first approver of iexpense/invoice is there any other possibility to improve the performance.how to post my query in this forum