| sample database: schema for asademo.db | Sample database schema |
| sargable predicates: about | Predicate analysis |
| savepoints: nesting and naming | Savepoints within transactions |
| savepoints: procedures and triggers | Transactions and savepoints in procedures and triggers |
| savepoints: within transactions | Savepoints within transactions |
| saving transaction results | Using transactions |
| saving: commands in Interactive SQL | Saving, loading, and running command files |
| SA_DEBUG group: debugger | Requirements for using the debugger |
| sa_migrate system procedure: about | Migrating databases to Adaptive Server Anywhere |
| sa_migrate system procedure: using | Migrating databases to Adaptive Server Anywhere |
| sa_migrate_create_fks system procedure: using | Migrating databases to Adaptive Server Anywhere |
| sa_migrate_create_remote_fks_list system procedure: using | Migrating databases to Adaptive Server Anywhere |
| sa_migrate_create_remote_table_list system procedure: using | Migrating databases to Adaptive Server Anywhere |
| sa_migrate_create_tables system procedure: using | Migrating databases to Adaptive Server Anywhere |
| sa_migrate_data system procedure: using | Migrating databases to Adaptive Server Anywhere |
| sa_migrate_drop_proxy_tables system procedure: using | Migrating databases to Adaptive Server Anywhere |
| sa_pause_workload_capture procedure: pausing the Index Consultant | Stopping the Index Consultant |
| sa_stop_index_consultant procedure: stopping the Index Consultant | Stopping the Index Consultant |
| sa_stop_workload_capture procedure: stopping the Index Consultant | Stopping the Index Consultant |
| scalar aggregates | Where you can use aggregate functions |
| scattered reads: performance | Use an appropriate page size |
| schedules: effects of serializability | Serializable schedules |
| schedules: effects of unserializable | Serializable schedules |
| schedules: serializable | Serializable schedules |
| schedules: serializable versus early release of locks | Early release of read locks |
| schedules: two-phase locking | Two-phase locking |
| scheduling of transactions | Serializable schedules |
| schema: exporting | Exporting table data or table schema |
| scripts: running in Interactive SQL | Saving, loading, and running command files |
| security: hiding objects | Hiding the contents of procedures, functions, triggers and views |
| security: procedures | Benefits of procedures and triggers |
| select list: about | The SELECT list: specifying columns |
| select list: aliases | Renaming columns in query results |
| select list: calculated columns | Computing values in the SELECT list |
| select list: EXCEPT statements | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| select list: in access plans | Reading access plans |
| select list: INTERSECT statements | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| select list: UNION operation | Combining sets with the UNION operation |
| select list: UNION statements | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| SELECT statement: about | Query overview |
| SELECT statement: aliases | Renaming columns in query results |
| SELECT statement: character data | Character strings and quotation marks |
| SELECT statement: column headings | Renaming columns in query results |
| SELECT statement: column order | Selecting specific columns from a table |
| SELECT statement: cursors | Using cursors on SELECT statements in procedures |
| SELECT statement: INSERT from | Adding data using INSERT |
| SELECT statement: INTO clause | Returning results as procedure parameters |
| SELECT statement: keys and query access | Using keys to improve query performance |
| SELECT statement: specifying rows | The WHERE clause: specifying rows |
| SELECT statement: strings in display | Character strings in query results |
| SELECT statement: Transact-SQL | Writing compatible queries |
| SELECT statement: variables | Writing compatible queries |
| selecting all columns from a table | Selecting all columns from a table |
| selecting specific columns from a table | Selecting specific columns from a table |
| selectivity estimates: reading in access plans | Graphical plans |
| selectivity estimates: using a partial index scan | Other uses for indexes |
| selectivity: item in access plans | Reading access plans |
| selectivity: reading in access plans | Graphical plans |
| self-joins | Self-joins |
| SELF_RECURSION option: Adaptive Server Enterprise | Transact-SQL trigger overview |
| semantic query transformations | Semantic query transformations |
| semantic transformations: about | Types of semantic transformations |
| semicolon: command delimiter | Check if you need to change the command delimiter |
| semijoin: query execution algorithms | Nested loops join Nested loops semijoin Hash semijoin |
| sending native statements to remote servers | Sending native statements to remote servers |
| separate primary and foreign key indexes | Separate primary and foreign key indexes |
| sequential scans: about | Sequential table scans |
| sequential scans: disk allocation and performance | Disk allocation for inserted rows |
| sequential table scans: about | Sequential table scans |
| sequential table scans: disk allocation and performance | Disk allocation for inserted rows |
| serializable schedules: about | Serializable schedules |
| serializable schedules: effect of | Serializable schedules |
| serializable schedules: two-phase locking | Two-phase locking |
| serializable schedules: versus early release of locks | Early release of read locks |
| server capabilities: remote data access | Server capabilities |
| server classes for remote data access | Server Classes for Remote Data Access |
| server classes: about | Server classes |
| server classes: asajdbc | Server class asajdbc |
| server classes: asaodbc | Server class asaodbc |
| server classes: asejdbc | Server class asejdbc |
| server classes: aseodbc | Server class aseodbc |
| server classes: db2odbc | Server class db2odbc |
| server classes: defining | Remote table mappings |
| server classes: msodbc | Server class mssodbc |
| server classes: ODBC | ODBC-based server classes Server class odbc |
| server classes: oraodbc | Server class oraodbc |
| server side loading | Performance considerations of moving data |
| server state: Index Consultant | Assessing the recommendations |
| servers and databases: compatibility | Servers and databases |
| servers: graphing with the Performance Monitor | Monitoring database statistics from Sybase Central |
| servers: starting a database without connecting | Starting a database without connecting |
| SET clause: UPDATE statement | Changing data using UPDATE |
| SET DEFAULT action: about | Referential integrity actions |
| set membership test | Set membership test |
| set membership test: =ANY | Testing set membership with IN conditions |
| set membership test: negation of | Testing set membership with IN conditions |
| SET NULL action: about | Referential integrity actions |
| set operations: about | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| set operations: NULL | Set operators and NULL |
| set operations: rules | Rules for set operations |
| SET OPTION statement: Transact-SQL | Setting options for Transact-SQL compatibility |
| setting breakpoints: debugger | Setting breakpoints |
| setting database options | Setting database options |
| setting options for Transact-SQL compatibility | Setting options for Transact-SQL compatibility |
| setting properties for database objects | Setting properties for database objects |
| setting the isolation level | Setting the isolation level |
| setting the isolation level from an ODBC-enabled application | Setting the isolation level from an ODBC-enabled application |
| shared objects: calling from procedures | Calling external libraries from procedures |
| shared versus exclusive locks | Types of locks |
| short plans: about | Text plans |
| short plans: Interactive SQL | Accessing the plan |
| short plans: SQL functions | Accessing the plan |
| SIGNAL statement: procedures | Default error handling in procedures and triggers |
| SIGNAL statement: Transact-SQL | Using the RAISERROR statement in procedures |
| single group by: query execution algorithms | Single group by |
| sort order: ORDER BY clause | The ORDER BY clause: sorting query results |
| sorted block joins: query execution algorithms | Nested block join and sorted block |
| sorting and unions | Sorting and unions |
| sorting query results | Sorting query results |
| sorting: query execution algorithms | Sorting and unions |
| sorting: with an index | Sorting query results |
| source code window: setting breakpoints | Working with breakpoints |
| special IDENTITY column | The special IDENTITY column |
| special Transact-SQL timestamp column and data type | The special Transact-SQL timestamp column and data type |
| specialized joins | Specialized joins |
| specifying a consolidated database | Specifying a consolidated database |
| specifying dates and times in procedures | Specifying dates and times in procedures |
| specifying proxy table locations | Specifying proxy table locations |
| sp_addgroup system procedure: Transact-SQL | Users and groups |
| sp_addlogin system procedure: support | Servers and databases |
| sp_addlogin system procedure: Transact-SQL | Users and groups |
| sp_adduser system procedure: Transact-SQL | Users and groups |
| sp_bindefault procedure: Transact-SQL | Defaults and rules |
| sp_bindrule procedure: Transact-SQL | Defaults and rules |
| sp_changegroup system procedure: Transact-SQL | Users and groups |
| sp_dboption system procedure: Transact-SQL | Setting options for Transact-SQL compatibility |
| sp_dropgroup system procedure: Transact-SQL | Users and groups |
| sp_droplogin system procedure: Transact-SQL | Users and groups |
| sp_dropuser system procedure: Transact-SQL | Users and groups |
| SQL 3 compliance | Designing Your Database |
| SQL 92 compliance | Designing Your Database |
| SQL 99 compliance | Designing Your Database |
| SQL Anywhere Studio: documentation | SQL Anywhere Studio documentation |
| SQL queries | SQL queries |
| SQL Remote: remote data access | Features not supported for remote data |
| SQL Remote: replicating and concurrent transactions | Replication and concurrency |
| SQL Server and remote access | Server class mssodbc |
| SQL standards | Designing Your Database |
| SQL standards: compliance | Differences from Other SQL Dialects |
| SQL standards: GROUP BY clause | Standards and compatibility |
| SQL standards: non-ANSI joins | Non-ANSI joins |
| SQL statements allowed in procedures and triggers | SQL statements allowed in procedures and triggers |
| SQL statements for implementing integrity constraints | SQL statements for implementing integrity constraints |
| SQL statements: logging in Sybase Central | Logging SQL statements as you work with a database |
| SQL statements: writing compatible SQL statements | Writing compatible SQL statements |
| SQL-3 compliance | Designing Your Database |
| SQL-92 compliance | Designing Your Database |
| SQL-99 compliance | Designing Your Database |
| SQL/3 compliance | Designing Your Database |
| SQL/92 compliance | Designing Your Database |
| SQL/99 compliance | Designing Your Database |
| SQL/XML: about | Obtaining query results as XML |
| SQL3 compliance | Designing Your Database |
| SQL: differences from other SQL dialects | Adaptive Server Anywhere SQL features |
| SQL: entering | SQL queries |
| SQLCA.lock: selecting isolation levels | Setting the isolation level from an ODBC-enabled application |
| SQLCA.lock: versus isolation levels | Typical types of inconsistency |
| SQLCODE variable: introduction | Errors and warnings in procedures and triggers |
| SQLSetConnectOption | Setting the isolation level from an ODBC-enabled application |
| SQLSTATE variable: introduction | Errors and warnings in procedures and triggers |
| SQL_TXN_ISOLATION | Setting the isolation level from an ODBC-enabled application |
| SQL_TXN_READ_COMMITTED: isolation level | Setting the isolation level from an ODBC-enabled application |
| SQL_TXN_READ_UNCOMMITTED: isolation level | Setting the isolation level from an ODBC-enabled application |
| SQL_TXN_REPEATABLE_READ: isolation level | Setting the isolation level from an ODBC-enabled application |
| SQL_TXT_SERIALIZABLE: isolation level | Setting the isolation level from an ODBC-enabled application |
| standard output: redirecting to files | Exporting query results |
| standards | Designing Your Database |
| standards and compatibility | Designing Your Database |
| star joins | Duplicate correlation names in joins (star joins) |
| starting a database without connecting | Starting a database without connecting |
| starting: Index Consultant | Starting the Index Consultant |
| statement-level triggers | Transact-SQL trigger overview |
| statements allowed in batches | Statements allowed in batches |
| statements: CALL | Procedure and trigger overview Calling procedures Control statements Passing parameters to procedures |
| statements: CASE | Control statements |
| statements: CLOSE | Cursor management overview |
| statements: COMMIT | Atomic compound statements Atomic compound statements Transactions and savepoints in procedures and triggers |
| statements: compound | Using compound statements |
| statements: CREATE DATABASE | Servers and databases |
| statements: CREATE DEFAULT | Defaults and rules |
| statements: CREATE DOMAIN | Defaults and rules |
| statements: CREATE PROCEDURE | Creating procedures Declaring parameters for procedures |
| statements: CREATE RULE | Defaults and rules |
| statements: CREATE TABLE | Creating compatible tables |
| statements: CREATE TRIGGER | Creating triggers |
| statements: DECLARE | Declarations in compound statements Cursor management overview Default error handling in procedures and triggers |
| statements: DISK | Device management |
| statements: DROP DATABASE | Servers and databases |
| statements: DUMP DATABASE | Servers and databases |
| statements: DUMP TRANSACTION | Servers and databases |
| statements: EXECUTE IMMEDIATE | Using the EXECUTE IMMEDIATE statement in procedures |
| statements: FETCH | Cursor management overview |
| statements: FOR | Control statements |
| statements: GRANT | Users and groups |
| statements: IF | Control statements |
| statements: LEAVE | Control statements |
| statements: LOAD DATABASE | Servers and databases |
| statements: LOAD TRANSACTION | Servers and databases |
| statements: logging | Logging SQL statements as you work with a database |
| statements: LOOP | Control statements Using cursors on SELECT statements in procedures |
| statements: MESSAGE | Default error handling in procedures and triggers |
| statements: OPEN | Cursor management overview |
| statements: optimization | The role of the optimizer |
| statements: OUTPUT | Exporting query results |
| statements: RAISERROR | Using the RAISERROR statement in procedures Transact-SQL-like error handling in the Watcom-SQL dialect |
| statements: RETURN | Returning a value using the RETURN statement |
| statements: REVOKE | Users and groups |
| statements: ROLLBACK | Transact-SQL trigger overview Transactions and savepoints in procedures and triggers |
| statements: SELECT | Writing compatible queries Writing compatible queries Returning results as procedure parameters |
| statements: SIGNAL | Using the RAISERROR statement in procedures Default error handling in procedures and triggers |
| statements: WHILE | Control statements |
| statistics are present and correct | Statistics are present and correct |
| statistics: access plans | Reading access plans Reading access plans |
| statistics: adding to the Performance Monitor | Adding and removing statistics |
| statistics: available | Monitoring database statistics from Windows Performance Monitor |
| statistics: column statistics | Optimizer estimates |
| statistics: displaying | Monitoring database statistics from Windows Performance Monitor |
| statistics: monitoring | Monitoring database performance |
| statistics: performance | Monitoring database statistics from Windows Performance Monitor |
| statistics: removing to the Performance Monitor | Adding and removing statistics |
| statistics: updating column statistics | Updating column statistics |
| steps in optimization | Steps in optimization |
| stored procedure language: overview | Transact-SQL procedure language overview |
| stored procedures: common table expressions in | Typical applications of common table expressions |
| stored procedures: debugging | Lesson 2: Debug a stored procedure |
| stored procedures: Transact-SQL stored procedure overview | Transact-SQL stored procedure overview |
| stored procedures: using in the FROM clause | The FROM clause: specifying tables |
| stored procedures: viewing individual profiling information | Viewing profiling information for a specific procedure |
| stored procedures: viewing profiling data | Profiling database procedures |
| stored procedures: viewing summary profiling data | Viewing procedure profiling information in Sybase Central |
| storing values: in common table expressions | Typical applications of common table expressions |
| storing XML documents in relational databases | Storing XML documents in relational databases |
| string and number defaults | String and number defaults |
| strings: matching | Matching character strings in the WHERE clause |
| strings: quotation marks | Character strings and quotation marks Character strings and quotation marks |
| structure of procedures and triggers | The structure of procedures and triggers |
| subqueries and joins | Subqueries and joins |
| subqueries in the HAVING clause | Subqueries in the HAVING clause |
| subqueries: about | Using Subqueries Introduction to subqueries |
| subqueries: ALL test | The ALL test |
| subqueries: ANY operator | The ANY test |
| subqueries: ANY test | The ANY test |
| subqueries: caching of | Subquery and function caching |
| subqueries: comparison operators | Comparison operators |
| subqueries: comparison test | Subquery tests Subquery comparison test |
| subqueries: converting to joins | Subqueries and joins Converting subqueries in the WHERE clause to joins |
| subqueries: correlated | Outer references Correlated subqueries |
| subqueries: existence test | Subquery tests Existence test |
| subqueries: GROUP BY | Subqueries in the HAVING clause |
| subqueries: HAVING clause | Subqueries in the HAVING clause |
| subqueries: IN keyword | Using lists in the WHERE clause |
| subqueries: nested | Nested subqueries |
| subqueries: optimizer internals | How subqueries work |
| subqueries: outer references | Subqueries in the HAVING clause |
| subqueries: quantified comparison test | Subquery tests Quantified comparison tests with ANY and ALL |
| subqueries: rewriting as EXISTS predicates | Rewriting subqueries as EXISTS predicates |
| subqueries: rewriting as joins | Subqueries and joins |
| subqueries: row group selection | Subqueries in the HAVING clause |
| subqueries: row selection | Using subqueries in the WHERE clause |
| subqueries: set membership test | Subquery tests Testing set membership with IN conditions |
| subqueries: types of operators | Subquery tests |
| subqueries: WHERE clause | Using subqueries in the WHERE clause Converting subqueries in the WHERE clause to joins |
| subquery and function caching | Subquery and function caching |
| subquery comparison test | Subquery comparison test |
| subquery set membership test: about | Testing set membership with IN conditions |
| subquery tests | Subquery tests |
| subquery transformations during optimization | Semantic query transformations |
| subquery unnesting | Subquery unnesting |
| subscriptions: data replication and concurrency | Replication and concurrency |
| substituting a value for NULL | Properties of NULL |
| subtotal rows: construction | The ROLLUP operation: adding summary information to GROUP BY queries |
| subtotal rows: definition | The ROLLUP operation: adding summary information to GROUP BY queries |
| subtotal rows: ROLLUP operation | The ROLLUP operation: adding summary information to GROUP BY queries |
| subtransactions: and savepoints | Savepoints within transactions |
| subtransactions: procedures and triggers | Transactions and savepoints in procedures and triggers |
| summarizing query results using aggregate functions | Summarizing query results using aggregate functions |
| summarizing, grouping and sorting query results | Summarizing, Grouping and Sorting Query Results |
| summary information: ROLLUP operation | The ROLLUP operation: adding summary information to GROUP BY queries |
| summary profiling data: events | Viewing procedure profiling information in Sybase Central |
| summary profiling data: stored procedures and functions | Viewing procedure profiling information in Sybase Central |
| summary profiling data: triggers | Viewing procedure profiling information in Sybase Central |
| summary rows: ROLLUP operation | The ROLLUP operation: adding summary information to GROUP BY queries |
| summary values | The GROUP BY clause: organizing query results into groups |
| summary values: about | Summarizing query results using aggregate functions |
| support: newsgroups | Finding out more and providing feedback |
| swap space: database cache | Dynamic cache sizing (UNIX) |
| Sybase Central Performance Monitor | Monitoring database statistics from Sybase Central |
| Sybase Central: altering tables | Altering tables (Sybase Central) |
| Sybase Central: and column defaults | Working with column defaults in Sybase Central |
| Sybase Central: column constraints | Working with table and column constraints in Sybase Central |
| Sybase Central: copying database objects | Copying database objects in Sybase Central |
| Sybase Central: copying tables | Copying tables or columns within/between databases |
| Sybase Central: creating databases | Creating databases (Sybase Central) |
| Sybase Central: creating indexes | Creating indexes |
| Sybase Central: creating tables | Creating tables |
| Sybase Central: deleting databases | Erasing a database |
| Sybase Central: deleting tables | Deleting tables |
| Sybase Central: displaying system objects | Displaying system objects in a database |
| Sybase Central: displaying system tables | Displaying system tables |
| Sybase Central: dropping views | Deleting views |
| Sybase Central: erasing databases | Erasing a database |
| Sybase Central: installing jConnect metadata support | Installing the jConnect metadata support to an existing database |
| Sybase Central: logging SQL statements | Logging SQL statements as you work with a database |
| Sybase Central: managing foreign keys | Managing foreign keys (Sybase Central) |
| Sybase Central: managing primary keys | Managing primary keys (Sybase Central) |
| Sybase Central: modifying views | Modifying views |
| Sybase Central: rebuilding databases | Rebuild tools |
| Sybase Central: setting a consolidated database | Specifying a consolidated database |
| Sybase Central: setting database options | Setting database options |
| Sybase Central: starting a database without connecting | Starting a database without connecting |
| Sybase Central: translating procedures | Using Sybase Central to translate stored procedures |
| Sybase Central: validating indexes | Validating indexes |
| symbols: string comparisons | Matching character strings in the WHERE clause |
| syntax-independent optimization | The role of the optimizer |
| SYSCOLSTAT: updating column statistics | Updating column statistics |
| SYSCOLUMNS view: conflicting name | Creating a Transact-SQL-compatible database |
| SYSINDEX table: index information | Indexes in the system tables |
| SYSINDEXES view: conflicting name | Creating a Transact-SQL-compatible database |
| SYSINDEXES view: index information | Indexes in the system tables |
| SYSIXCOL table: index information | Indexes in the system tables |
| sysservers system table: remote servers | Creating remote servers |
| SYSTABLE system table: view information | Views in the system tables |
| system administrator: Adaptive Server Enterprise | Administrative roles |
| system catalog: Adaptive Server Enterprise compatibility | System tables |
| system functions: tsequal | The special Transact-SQL timestamp column and data type |
| system objects | Displaying system objects in a database |
| system objects: displaying | Displaying system tables |
| system security officer: Adaptive Server Enterprise | Administrative roles |
| system tables: Adaptive Server Enterprise compatibility | System tables |
| system tables: and indexes | Indexes in the system tables |
| system tables: displaying | Displaying system tables |
| system tables: information about referential integrity | Integrity rules in the system tables |
| system tables: owner | System tables |
| system tables: Transact-SQL name conflicts | Creating a Transact-SQL-compatible database |
| system tables: views | Views in the system tables |
| system triggers: implementing referential integrity actions | Referential integrity actions |
| system views: and indexes | Indexes in the system tables |
| system views: information about referential integrity | Integrity rules in the system tables |
| SYSVIEWS view: view information | Views in the system tables |