<1/4>

“No Bugs” Bunny

unnamed.png

“No Bugs” Bunny
Sarcastic Architect

Hobbies: Thinking Aloud, Arguing with Managers, Annoying HRs, Calling a Spade a Spade, Keeping Tongue in Cheek

BB_userpic_0012.png

Once upon a time, in a rabbit outsourcing warren of Bunnylore, there was a young software developer bunny. And as a developer, she has had one very unusual treat: she was obsessed with eliminating all the bugs she can get his forelegs on. So, it is not surprising that her friends called her a “No Bugs” Bunny (or simply “NoBugs”).

Later on, she grew up, so she decided that “Bunny” in her name has became inappropriate (not to mention potential arguments with Warner Brothers), so she has asked all her friends to call her “No Bugs” Bunny. She has made a career as a team lead and software architect, and they lived happily ever after.

OLTP Optimization Cheat Sheets for dbdevs and DBAs

September 5, 2017 by “No Bugs” Bunny

Execution Plans with no index, single-column index, and multi-column index

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 more

DB Execution Plans for C++/Java Developers, and for anybody who has read Knuth

August 29, 2017 by “No Bugs” Bunny

Execution Plans with no index, single-column index, and multi-column index

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 more

Understanding Correlated and Uncorrelated Sub-queries in SQL

August 24, 2017 by “No Bugs” Bunny


Quote:

A correlated sub-query is a type of query, where inner query depends upon the outcome of the outer query in order to perform its execution.

Another Quote:

Correlated sub-queries are slower.

Filed under: On.ProgrammingTips and Tricks

Tagged With: SQLDatabase
Read more

OLTP DB Optimizations 101 - Thinking in Terms of Execution Plans

August 22, 2017 by “No Bugs” Bunny

DB Optimizations: Execution Plans

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