“No Bugs” Bunny
OLTP Optimization Cheat Sheets for dbdevs and DBAs
September 5, 2017 by • “No Bugs” Bunny
Quote:
Have I already mentioned that you DO need to understand execution plans?
Another Quote:
DO keep in mind that maintaining indexes has its own cost
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IXOn.ProgrammingOptimizations
Read moreDB Execution Plans for C++/Java Developers, and for anybody who has read Knuth
August 29, 2017 by • “No Bugs” Bunny
Quote:
If I was a compiler-with-ability-to-create-indexes-as-I-need-it – what would I do to make The Ideal Execution Plan™ for this request?
Another Quote:
When we have that ideal-execution-plan – we still need to convince our SQL compiler to use it
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IX
Read moreOLTP DB Optimizations 101 - Thinking in Terms of Execution Plans
August 22, 2017 by • “No Bugs” Bunny
Quote:
to realize how our queries are working – we need to start thinking in terms of so-called “execution plans”.
Another Quote:
it can be faster to use Table Scan rather than Index-Scan+fetch over such a low-selectivity index
Filed under: Book: D&D of MOGs1st beta of Vol. VII-IX
Read more




