9 Replies Latest reply: Jan 30, 2013 8:37 AM by Dom Brooks RSS

    SQL query optimisation

    988076
      Hello,

      I am running the following query on the tables which have 50lacs of records each and hence the time taken is very huge:

      select table1.column1 , table1.column2, table2.column2 from table1, table2 where
      table1.column1=table2.column1
      and table1.column2 <> table2.column2

      Please help me to optimise the above query.

      Thanks,
      Asha