C

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