0 Replies Latest reply on Sep 29, 2019 5:49 PM by sandeepgupta18

    Sql Query Optimiztion

    sandeepgupta18
    sandeepgupta18 Sep 29, 2019 5:49 PM

      Hi All,

       

      Can anyone help  me query Optimization

      I used two tables A & B

      when querying from A its perfect but when I join it with B it took 5 min and return on 60k records.

      I tried to find out reason and found   there is no index on that table(only Non-unique indexes) and table contains 20 millions of records.

       

       

      Now the problem is index can not be created on that table and neither it can be  drop or recreate  ..

      All stats are gathered already

       

      can anyone suggest something on this..

       

      Thanks in Advance