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]

random numbers, using instead of system-generated values 2nd

range scans

     converting variable-length comparison to common case

     on clustered data

     reverse indexes and

     simple or range searching on dates

range-clustering (DB2)

range-partitioning

ranges

     aggregating by range (bands)

     importance of well-defined boundaries

ranking functions (SQL Server)

recovering databases

recursive with statement 2nd

     adjacency model, top-down tree walk

     propagating percentages across different tree levels

     substituting materialized path model for

redundant data

reference data in dimension tables

referencing tables, preventing insertions into

relational databases

     hierarchical databases vs.

     processing, confusing with object-oriented methods

     SQL and

relational model

     coherence of

     flexibility of, sacrificing by strongly structured data

     two-valued logic

     view of a tree

relational operations, reporting requirements vs.

relational theory

relations

     associating large numbers of possible characteristics in

     ordering information vs.

remote data

     querying

     transparent references to

remote data sources

remote validation checks

reorganizations of databases

reporting requirements

request type, partitioning by

requirements, evolution of

response times

result sets

     criteria defining

     difficulty of spotting incorrect data

     filtering conditions

         evaluation of

         large quantities of data

         meaning of

         proportions of retrieved data

     large

     obtained by aggregation

     predicated on absence of data

     size of 2nd

     small intersection of broad criteria

     small intersection, indirect broad criteria

     small result set, indirect criteria

     small, from direct, specific criteria

retrieval ratios

returning ... into ... clause

reverse indexes

     solving contention problems

right-padding function (rpad( ))

risk exposure in a financial structure

round-robin partitioning

row_number( ) OLAP function 2nd 3rd

rownums (Oracle) 2nd

rows

     associated with index key, physical closeness of

     columns that should have been rows

     emptying a table of all rows

     locking 2nd

     matching several list items, selecting

     ordering of, forcing

     physical location, finding with an index

     primary key, defining

     proportions of retrieved data

     that should have been columns

     updating and inserting, dedicated statements for

rpad( ) function (right-padding)