IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Absolutely not
Post #415,933
by crazy
12/7/16 11:30:55 AM
12/7/16 11:30:55 AM
Reply
New Absolutely not
TPS is total volume. Which nothing to do with data skew. New or changing field contents can dramatically change which indexes to use or how to use them, or to use them at all, which modifies query plan.
Post #415,992
by malraux
Picture of malraux
12/13/16 9:07:05 AM
12/13/16 9:07:05 AM
Reply
New This.
The larger the data load, the bigger the potential change in index distribution.
Regards,
-scott
Welcome to Rivendell, Mr. Anderson.
     How much impact should automatic query plan optimization have? - (drook) - (9) - Dec. 5, 2016, 05:14:41 PM EST
         Realistic volume, perhaps? - (scoenye) - Dec. 6, 2016, 06:42:11 PM EST
         You should automatically collect stats on an ongoing basis - (crazy) - (6) - Dec. 6, 2016, 07:07:31 PM EST
             One-off event - (drook) - (5) - Dec. 6, 2016, 07:25:03 PM EST
                 Isn't that "one off" stuff... - (Another Scott) - Dec. 6, 2016, 08:11:35 PM EST
                 Huh? - (crazy) - (3) - Dec. 6, 2016, 08:49:20 PM EST
                     What I mean is we'll keep having one-off events - (drook) - (2) - Dec. 6, 2016, 09:45:02 PM EST
                         Absolutely not - (crazy) - (1) - Dec. 7, 2016, 11:30:55 AM EST
                             This. - (malraux) - Dec. 13, 2016, 09:07:05 AM EST
         I've not worked with a DB that needed that to happen. - (static) - Dec. 7, 2016, 12:50:35 AM EST

Travelling at the speed of light with the headlights on.
32 ms