Why this behaviour after creating index?


  • Hi All,

      I had a performance issue with SQL Server while getting the datausing .net. so created Index on two fields yesterday and the reports were running fast, but today I see that they have slowed again, what could be the reason and how to resolve this. Thanks for any help or tips...


    Friday, August 23, 2013 4:29 PM


    1. check amount data inserted & deleted after index creation
    2. check index fragmentation level
    3. update your statistics 
    4. also check the waittype coming during running report query

    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Saturday, August 24, 2013 2:23 PM