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]

object-oriented (OO) practice, relational database processing vs.

offensive coding with SQL

OLAP functions

     current value for an item at a given date

     operating on sliding windows

     row_number( )

"one size fits all" philosophy

online analytical processing (OLAP), DB2

online transaction processing (OLTP)

operating mode

operating systems, contention issues and

operational data stores

operations (data manipulation), ranking in terms of overall cost

operations, sensitivity to data volume increases

     disentangling subqueries

     insensitivity to

     linear sensitivity to

     non-linear sensitivity to

optimizers 2nd

     causing to take a different course

     checking execution plan

     circumstances not allowing efficient working of

     data distributions and

     directives

     directives or hints to

     heterogeneous, on distributed systems

     join filtering conditions and

     joins and filtering conditions

     limits of

     queries and

     rewriting of queries

     views and

Oracle

     connect by operator 2nd 3rd

         propagating percentages across tree levels

         substituting materialized path model for

     dbms_application_info package

     rownums 2nd

     tablespace referred to as a partition

Oracle 9i Database, merge statement

order of evaluation, filtering conditions

ordering criteria

ordering information, relations vs.

orders/order_detail relationship

outer joins

     expressing nonexistence with

     using in dynamically defined search query

outer queries

outriggers