SQL Tuning [Electronic resources] نسخه متنی

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