In my SQL Masterclass, I frequently remind participants of the fact how important statistics are for a modern cost based optimiser. For instance, if you consider the fact that in an average E-Banking system's bookings table, you will probably have a transaction amount histogram like the following: In other words, most of your transactions are … Continue reading Why You Should Design Your Database to Optimise for Statistics
Tag: statistics
Logon Triggers: The Oracle Database Magic Bullet
Imagine you want to collect detailed usage statistics to tune your Oracle database, e.g. if you want to have A-Rows and A-Time values in your execution plans (by default, Oracle only reports E-Rows and E-Time with "E" for "Estimated". But usually, you will care more about the "A" for "Actual"). All you have to do … Continue reading Logon Triggers: The Oracle Database Magic Bullet
Silly Metrics: The Most Used Java Keywords
Tell me... Haven't you ever wondered how many times you actually "synchronized" something? Didn't you worry about not using the "do {} while ()" loop structure often enough? Are you an expert in applying "volatile"? Do you "catch" more often than you "try"? Is your program rather "true" or rather "false? And how did that "goto" … Continue reading Silly Metrics: The Most Used Java Keywords
Get hidden feature requests from your users
In general, I'm not a marketing guy, I prefer to develop code. But when I look at modern marketing tools that we developers have created for our marketing friends, I'm getting a bit jealous. Take this blog, for instance. It's the perfect jOOQ marketing tool. Check out my 2013 visitor statistics: Quite obviously, my February … Continue reading Get hidden feature requests from your users