O

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