7 Replies Latest reply: Nov 16, 2011 4:56 PM by Srini Chavali-Oracle RSS

    CATS runs 10 times faster than the SELECT stmt, why?

    ora001
      Oracle 11gR2
      Exadata

      CATS runs 10 times faster than the SELECT stmt, why?

      e.g.
      SELECT A,B,C...FROM V WHERE A IN (1,2,3,4) GROUP BY A,B,C....
      Elapsed: x mins

      CREATE TABLE rslt AS
      SELECT A,B,C...FROM V WHERE A IN (1,2,3,4) GROUP BY A,B,C....
      Elapsed: x/10 mins

      Any thoughts?

      Thanks,
      Prakash