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
|
