5 Replies Latest reply: May 21, 2014 10:26 AM by rp0428 RSS

    Select statement takes 25 min but counting the records takes 6 hours!




      I have a select statements which includes some joins among 3 tables with some conditions!

      The whole SELECT statements takes 25 minutes to finish but when i try to count the records OR *create table as select ...* then it takes 6 hours to finish!


      Do you have any idea , what might be the problem????



      Thanks in advance!