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]

C# code

cardinality (low)

Cartesian joins 2nd

case expression

CBOs (cost-based optimizers)

Celko, Joe 2nd

centralizing data

changing data, concurrency and

     contention

         architectural solutions

         DBA solutions for

         developmental solutions

         insertion and

         results from measures limiting

     locking

         committing and

         granularity of

         lock handling

         scalability and

child with multiple parents

classic SQL patterns

     large result set

     nine common situations, listed

     result set obtained by aggregation

     result set predicated on absence of data

     self-joins on one table

     simple or range searching on dates

     small intersection of broad criteria

     small intersection, indirect broad criteria

     small result set, direct specific criteria

         criterion indexability

         data dispersion

         index usability

         query efficiency and index usage

     small result set, indirect criteria

client/server environment, database connections

clustered indexes 2nd

     drawbacks of

clustering data with partitioning

clustering index

coalesce( ) function

coarse (granularity)

Codd, E.F.

coding offensively with SQL

columns

     auto-incremented

         effects on contention

     Boolean, qualifying

     locking

     rows that should have been

     single, that should have been something else

     that should have been rows

comments, identifying programs and critical modules

commercial off-the-shelf (COTS) software package

commit statements

committing, locking and

comparisons

complexity

     degree for the request, performance and

     introduced by storage options other than the default

     sources of hidden complexity

composite primary keys

     order of columns in

concurrency

     considering in SQL code design

     data modifications

         contention

         locking

     data-driven partitioning and

     database engine as service provider

         increasing load revealing performance problems

         indexes, virtues of

     increased, with partitioning

concurrent updates, foreign key indexing for

conditional logic

conditions

     applied at the wrong place

     order of evaluation

connect by operator (Oracle) 2nd 3rd

     propagating percentages across different tree levels

     substituting materialized path model for

constraints

     implicit, unsoundness of

     major impact of

     violation of

containers, contention when trying to access

content lists, indexes and

contention 2nd

     architectural solutions

     DBA solutions for

     developmental solutions

     indexing system-generated primary keys

     insertion and

     physical layout of data and

     results from measures limiting

correctness of data

correlated subqueries 2nd

     determining when to use

     looking for rows with no matching data

     performance effects when processing huge numbers of rows

     testing for existence without other search criteria

     un-correlating 2nd

     volume increases and

corruption of data

cost-based optimizers (CBOs)

COTS (commercial off-the-shelf) software package

counts

     redundant 2nd

     using as test for existence

CPU, excessive use of

CPU-intensive operations, high level of concurrency for

credit card validation procedures

criteria

     (see also classic SQL patterns; conditions; filtering conditions)

     defining result sets

     dynamic search criteria

     quality of

current table and historical table, using

current values

cursor loops

customer, defining