3 Replies Latest reply on Sep 25, 2013 8:58 PM by JAGORACLE

    Query on a table runs more than 45mins(after stats) and same query runs 19secs(before stats - rebuild)

    DBA_Guide

      Query on a table runs more than 45mins(after stats) and same query runs 19secs(before stats - rebuild) - Not sure what the cause is.

       

      - Analysed the explain the plan

      - different explain plan used afterr stats gather.

       

      Any idea what could be the cause with this kind of difference.

       

      Thank you!