1 2 Previous Next 16 Replies Latest reply: Feb 18, 2013 9:35 AM by 985871 Go to original post RSS
      • 15. Re: Need help to Tune a Query
        moreajays
        Hi,

        Try creating index on ACCOUNT (ACCOUNT_TYPE_ID,ACCOUNT_ID) , & check if inner query FTS gets removed by Index Scan
        Else and a.ACCOUNT_ID not IN condition need to change as not exists

        Thanks,
        Ajay More
        http://www.moreajays.com
        • 16. Re: Need help to Tune a Query
          985871
          Ajay ,

          As of now i have removed the union all statement as after removing also i was getting the same result and in just 0.36 ms. I have sent to the dev team and waiting to hear from them .

          Many thanks for your help. I SHall try with creating an index once i get a reply from them

          Regards
          1 2 Previous Next