The Art of SQL

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

many-to-many relationship resolving between two tables

master/detail relationships

matching, finding the best match

materialized path model (SQL trees) 2nd

     aggregating values stored in leaf nodes

         computing head counts at every level

     bottom-up tree walk

     path explosion

     substituting for connect by or recursive with

     top-down walk

materialized views

     pre-joining vs.

measurement values, storage of

memory

     addresses for data storage

     corrupting by mishandling pointers

merge statement, Oracle 9i

merge table (MySQL)

meta-design

mini-dimensions

modeling

     head counts

         computing at every level

modularity, database programming and

monitoring performance

     defining good performance

         checking against standards

         defining performance goals

         knowing what you get

         knowing what you spend

     execution plans

         forcing the right plan

         identifying the fastest

         using properly

     server load

     slow database

     statements currently being executed

     thinking in business tasks

     what really matters in improving queries

"more-flexible-than-thou" construct

movie database

     designing database and main search query

     redesigning main search query for tight fit

     wrapping SQL in PHP

MySQL

     last_insert_id( )

     merge table

     PHP, using with