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!

Tune the following Query

Discussion in 'SQL PL/SQL' started by jagadekara, Jun 30, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,176
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks Rajen,

    I used to_char because, I used max(asset_number) and ent.transaction_number in case. So asset_number,ent.transaction_number is a character data type. That's why I used to_char(asset_id).

    But now I checked that and removed fa_transaction_history_trx_v and used FA_TRANSACTION_HEADERS
    and instead of asset_number I used asset_id.

    And no need of ent.transaction_number. So I removed else ent.transaction_number.

    Now it is coming fine. Took Less time to execute.

    Thanks All for giving me your valuable suggestions....