SQL Tuning
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]
cache-hit ratio 2nd caching in application 2nd B-tree indexes and block buffer cache continuous growth pattern and full table scans and indexed table access and LRU caching 2nd performance effects of purge eldest pattern and purge, not by age pattern and self-caching 2nd calcuations [See benefit-to-cost ratio; cache-hit ratio; correlation preference ratio; join ratio; filter ratio] capitalized text used in this book Cartesian join 2nd Cartesian product optimizing execution plan for 2nd resulting from absence of join resulting from query with multiple roots 2nd 3rd CBO [See cost-based optimizer] Central Processing Unit [See CPU] cloud of nodes COALESCE() function cold blocks 2nd columns relevance to SQL tuning statistics for, used by cost-based optimizer comments about this book, sending complete purge and regrowth pattern complex queries 2nd abnormal outer joins in cyclic joins in disconnected queries joins with no primary key in multiple roots in one-to-one joins in set operations in subqueries in views in conditions [See filters; joins; selectivity] contact information for this book continuous growth pattern conventions used in this book corner-case problems abnormal query diagrams indicating changing functionality for view-using queries causing correlated subqueries, forcing evaluation of correlation joins 2nd anti-join 2nd in query diagrams semi-join 2nd correlation preference ratio 2nd 3rd cost-based optimizer 2nd choosing controlling execution plans with response to varying table and index sizes rule-based optimizer used with statistics affecting 2nd CPU (Central Processing Unit) cyclic join graph 2nd
|