Post reply

After CREATE STATISTICS system become slow

  • March 27, 2006 at 7:26 am

    #189924

    Dear All,

    As per the suggestion of index tuning wizard, I CREATE STATISTICS on tables. After that user compiling that system is slow.

     

    Pls advice me how can I solve the issue.

     

    Is CREATE STATISTICS cause performance problems?

     

    Regards

     

    Mathew

  • March 27, 2006 at 9:32 am

    #628961

    Hello Mathew,

    I usually run

    DBCC FREEPROCCACHE

    after updating statistics or in your case after creating statistics. SQL Server uses statistics during creating execution plans when compiling. DBCC FREEPROCCACHE will free the cache and most of the things will be recompiled to use the new statistics.

    There is one thing: since the compilation process takes time than the first execution of a statement or SP will be slower than usual.

    Regards,Yelena Varsha

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply