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!

very urgent....need help for tuning tis package

Discussion in 'SQL PL/SQL' started by vijayspecial, Jul 10, 2013.

  1. vijayspecial

    vijayspecial Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    i Have attached nss_pivot package.. can any one help me to tune tis package..
    If possible can any give some idea or change the neccessaary this in the package and tune..
    please this is urgent...
     

    Attached Files:

  2. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    what do you understand as tuning?
    optimization is an extensive and difficult subject.

    There are questions to you:
    1) what performance concerns you faced when using this packet?
    2)
    you can provide the diagram description, structure of tables?

    p.s. you a packet have a code which could be rewritten directly