Please enable JavaScript.
Coggle requires JavaScript to display documents.
Learning what the optimizer does, Understanding execution plans, khoa, Tân…
Learning what the optimizer does
Optimizations by example
APPLY TRANSFORMATION -> WHAT THE PLANNER DOES TO SPEED UP QUERY -> THỰC SỰ VÀO VIỆC, NỐI TIẾP VỚI CÁI QUERY MENTION LÚC ĐẦU
STEP 1: INLININNG THE VIEW
STEP 2: FLATTENING SUBSELECTS
APPLY EQUALITY CONSTRAINTS
EXHAUSTIVE SEARCHING
MAKE THE PROCESS FAIL
EVALUATE JOIN OPTIONS -> SOME JOIN OPTION OF POSTGRE
HASH JOIN
what
how
why
MERGE JOIN
how
why
what
NESTED LOOP
what
how
why
CONSTANT FOLDING
UNDERSTANDING FUNCTION INLINING
JOIN PRUNING
SPEEDUP SET OPERATION
Understanding execution plans
Approaching plans systematically
MAKE EXPLAIN MORE VERBOSE
Spotting problems
SPOTTING CHANGES IN RUNTIME
INSPECTING ESTIMATES
INSPECTING BUFFER USAGE
FIXING HIGH BUFFER USAGE
khoa
Tân