Home Forums SQL Server 2005 Administering A Simple Select, Update Query with where condition is taking much time RE: A Simple Select, Update Query with where condition is taking much time

  • Hi,

    There may be no of reasons why it is happening.

    1. Do you have indexes on those tables.

    2. When did you update your indexes and statistics last.

    3. Do you have any other processes or blockings while select or update is going on these tables

    4. Did you study the query plan . you can find out what exactly is happening in your query plan if you dont have any blockings etc..

    Thanks

    Chandra Mohan N

    [font="Verdana"]Thanks
    Chandra Mohan[/font]