• Koen Verbeeck (8/29/2013)


    Some of the things I'd check:

    * are statistics updated?

    * is the table indexed? Are they indexed well?

    * Are there unnecessary indexes?

    * compression

    * partitioning

    I am going through the list provided by You one by one. Regarding compression, Does it really improve the performance !!!! Does it not have a extra overhead to read the content (I am not contrary to your statement , i am just asking :-)) . It would be great if you have some bookmarked link to pros & cons of compression and you can pass it on.