Hello all,

1.     Is there a good explanation why updating the statistics:
update statistics tableX;

made this query 2x times slower?   (it was 27 seconds before, now it’s 
somewhere between 60 – 90 seconds)
select count(*) from tableX;
+------------------------------------------+
|                 COUNT(1)                 |
+------------------------------------------+
| 5786227                                  |
+------------------------------------------+
1 row selected (62.718 seconds)

(If possible ☺ ) how can I “drop” those statistics?

2. Why there is nothing (like a counter / attribute for the table) to obtain 
the number of rows in one table fast?

Thank you,
   Constantin

Reply via email to