Performance not same for all tables. RRS feed

  • Question

  • Hi, when i try to do a count from 2 tables in same filegroup the performance differs a lot.  Both have around 200 million rows.  One comes back within 5 secs but the other takes 5 min.  Any ideas as to whhy this would be?  Both have same kind of indexes and are in primary filegroup.

    • Changed type Brad_Schulz Tuesday, March 2, 2010 6:27 PM It's a question
    Tuesday, March 2, 2010 6:24 PM


All replies