1 2 Previous Next 16 Replies Latest reply on Feb 18, 2013 3:35 PM by 985871 Go to original post
      • 15. Re: Need help to Tune a Query

        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

        Ajay More
        • 16. Re: Need help to Tune a Query
          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

          1 2 Previous Next