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

    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!