Post reply

creating index and updating statistic

  • March 5, 2008 at 2:45 am

    #120681

    hello,

    I was creating index but no effect on my sql transaction. is it neccessary to updating statistic after creating an index to use it ?

    French Geek.
    http://blog.developpez.com/ylarvor
    I work my english 🙂

  • March 5, 2008 at 3:30 am

    #785381

    No, normally you don't have to run update statistics after creating an index. It should have effect on your SQL immediately. Perhaps have a look at your query with execution plan or run query optimizer to see what advices optimizer you gives.

    ------------------------------------------------------------
    Application Architect and Developer @ Traffic4u
    Visit my profile on LinkedIN

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

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