| objects that can be locked | Objects that can be locked |
| objects: hiding | Hiding the contents of procedures, functions, triggers and views |
| obtaining database statistics from a client application | Obtaining database statistics from a client application |
| obtaining query results as XML | Obtaining query results as XML |
| occasionally connected users: replicating data and concurrency | Replication and concurrency |
| ODBC server classes | ODBC-based server classes Server class odbc |
| ODBC: applications | Setting the isolation level from an ODBC-enabled application |
| ODBC: applications, and locking | Setting the isolation level from an ODBC-enabled application |
| ODBC: external servers | Defining ODBC external servers |
| odbcfet | Monitoring query performance |
| OLAP: ROLLUP operation | The ROLLUP operation: adding summary information to GROUP BY queries |
| OLAP: subtotal rows | The ROLLUP operation: adding summary information to GROUP BY queries |
| ON clause: joins | Explicit join conditions (the ON phrase) |
| ON EXCEPTION RESUME clause: about | Error handling with ON EXCEPTION RESUME |
| ON EXCEPTION RESUME clause: not with exception handling | Using exception handlers in procedures and triggers |
| ON EXCEPTION RESUME clause: stored procedures | Default error handling in procedures and triggers |
| ON EXCEPTION RESUME clause: Transact-SQL | Transact-SQL-like error handling in the Watcom-SQL dialect |
| ON phrase: joins | Explicit join conditions (the ON phrase) |
| one-to-many relationships: definition of | Relationships |
| one-to-many relationships: resolving | Step 4: Resolve the relationships |
| one-to-one relationships: definition of | Relationships |
| one-to-one relationships: resolving | Step 4: Resolve the relationships |
| online analytical processing: ROLLUP operation | The ROLLUP operation: adding summary information to GROUP BY queries |
| OPEN statement: procedures | Cursor management overview |
| opening the Sybase Central Performance Monitor | Opening the Sybase Central Performance Monitor |
| OPENXML function: using | Importing XML using OPENXML |
| operators: arithmetic | Computing values in the SELECT list |
| operators: connecting conditions | Connecting conditions with logical operators |
| operators: NOT keyword | Using comparison operators in the WHERE clause |
| operators: precedence | Computing values in the SELECT list |
| optimization for minimum or maximum functions | Optimization for minimum or maximum functions |
| optimization goal: in access plans | Reading access plans |
| optimization of queries: about | The role of the optimizer |
| optimization of queries: assumptions | Underlying assumptions |
| optimization of queries: reading access plans | Reading access plans |
| optimization of queries: rewriting subqueries as EXISTS predicates | Rewriting subqueries as EXISTS predicates |
| optimization of queries: steps in | Steps in optimization |
| optimization: cost based | The role of the optimizer |
| optimization: reading access plans | Reading access plans |
| optimization: using indexes | Special optimizations |
| optimize for first rows or for entire result set | Optimize for first rows or for entire result set |
| optimizer estimates: about | Optimizer estimates |
| optimizer: about | The role of the optimizer How the optimizer works |
| optimizer: assumptions | Underlying assumptions |
| optimizer: predicate analysis | Predicate analysis |
| optimizer: role of | The role of the optimizer |
| optimizer: semantic subquery transformations | Semantic query transformations |
| optimizer: semantic transformations | Types of semantic transformations |
| optional foreign keys | Enforcing referential integrity |
| optional relationships | Relationships |
| options: BLOCKING | The BLOCKING option |
| options: DEFAULTS | Table structures for import |
| options: ISOLATION_LEVEL | Setting the isolation level |
| options: setting database options | Setting database options |
| OR: using logical operators | Connecting conditions with logical operators |
| Oracle and remote access | Server class oraodbc |
| Oracle databases: migrating to Adaptive Server Anywhere | Migrating databases to Adaptive Server Anywhere |
| oraodbc server class | Server class oraodbc |
| ORDER BY and GROUP BY | ORDER BY and GROUP BY |
| ORDER BY clause: GROUP BY | ORDER BY and GROUP BY |
| ORDER BY clause: limiting results | Explicitly limiting the number of rows returned by a query |
| ORDER BY clause: performance | Sorting query results |
| ORDER BY clause: sorting query results | The ORDER BY clause: sorting query results |
| order-by: item in access plans | Reading access plans |
| ordered distinct: query execution algorithms | Ordered distinct |
| ordered group by: query execution algorithms | Ordered group by |
| ordering of transactions | Serializable schedules |
| organization: of data, physical | Physical data organization and access |
| organizing query results into groups | The GROUP BY clause: organizing query results into groups |
| orphan and referential integrity | Locking during inserts |
| other uses for indexes | Other uses for indexes |
| OUT parameters: defined | Declaring parameters for procedures |
| outer joins: about | Outer joins |
| outer joins: and join conditions | Outer joins and join conditions |
| outer joins: complex | Understanding complex outer joins |
| outer joins: in Transact-SQL | Transact-SQL outer joins (*= or =*) |
| outer joins: of views and derived tables | Outer joins of views and derived tables |
| outer joins: restrictions | Transact-SQL outer join limitations |
| outer joins: star join example | Duplicate correlation names in joins (star joins) |
| outer joins: Transact-SQL | Compatibility of joins |
| outer joins: Transact-SQL, restrictions on | Transact-SQL outer join limitations |
| outer joins: Transact-SQL, views and | Using views with Transact-SQL outer joins |
| outer references: about | Outer references |
| outer references: aggregate functions | Where you can use aggregate functions |
| outer references: HAVING clause | Subqueries in the HAVING clause |
| output redirection | Exporting query results |
| OUTPUT statement | Exporting query results |
| OUTPUT statement: about | Export tools |
| OUTPUT statement: using to export data as XML | Exporting relational data as XML from Interactive SQL |
| outputting nulls | Outputting NULLs |
| outputting: export tools | Export tools |
| outputting: exporting data | Importing and exporting data |
| outputting: exporting databases | Exporting databases |
| outputting: exporting query results | Exporting query results |
| outputting: exporting tables | Exporting tables |