| abbreviations used in access plans | Reading access plans |
| access plans caching | Access plan caching |
| access plans: abbreviations | Reading access plans |
| access plans: about | The role of the optimizer |
| access plans: caching of | Access plan caching |
| access plans: context sensitive help | Graphical plans |
| access plans: customizing | Graphical plans |
| access plans: explanation of statistics | Reading access plans |
| access plans: graphical plans | Graphical plans |
| access plans: Interactive SQL | Accessing the plan |
| access plans: long text plans | Text plans |
| access plans: printing | Graphical plans |
| access plans: reading | Reading access plans |
| access plans: short text plans | Text plans |
| access plans: SQL functions | Accessing the plan |
| accessing remote data | Accessing Remote Data |
| accessing remote data from PowerBuilder DataWindows | Accessing remote data from PowerBuilder DataWindows |
| accessing remote data: basic concepts | Basic concepts to access remote data |
| accessing tables: index scan and sequential scan | Accessing tables |
| actions: CASCADE | Referential integrity actions |
| actions: RESTRICT | Referential integrity actions |
| actions: SET DEFAULT | Referential integrity actions |
| actions: SET NULL | Referential integrity actions |
| Adaptive Server Anywhere SQL features | Adaptive Server Anywhere SQL features |
| Adaptive Server Anywhere: differences from other SQL dialects | Adaptive Server Anywhere SQL features |
| Adaptive Server architectures | Adaptive Server architectures |
| Adaptive Server Enterprise: compatibility | An overview of Transact-SQL support |
| Adaptive Server Enterprise: compatibility in data import/export | Adaptive Server Enterprise compatibility |
| Adaptive Server Enterprise: GROUP BY compatibility | Compatibility with Adaptive Server Enterprise |
| Adaptive Server Enterprise: migrating to Adaptive Server Anywhere | Migrating databases to Adaptive Server Anywhere |
| add foreign key wizard: using | Managing foreign keys (Sybase Central) |
| adding and removing statistics | Adding and removing statistics |
| adding data: about | Adding, Changing, and Deleting Data |
| adding data: adding NULL | Inserting values into specific columns |
| adding data: BLOBs | Inserting documents and images |
| adding data: column data INSERT statement | Inserting values into specific columns |
| adding data: constraints | Inserting values into specific columns |
| adding data: defaults | Inserting values into specific columns |
| adding data: into all columns | Inserting values into all columns of a row |
| adding data: using INSERT | Adding data using INSERT |
| adding data: with SELECT | Adding new rows with SELECT |
| adding new rows with SELECT | Adding new rows with SELECT |
| adding, changing, and deleting data: about | Adding, Changing, and Deleting Data |
| administrator role: Adaptive Server Enterprise | Administrative roles |
| aggregate functions: about | Summarizing query results using aggregate functions |
| aggregate functions: Adaptive Server Enterprise compatibility | Compatibility with Adaptive Server Enterprise |
| aggregate functions: ALL keyword | Summarizing query results using aggregate functions |
| aggregate functions: data types | Aggregate functions and data types |
| aggregate functions: DISTINCT keyword | Using aggregate functions with DISTINCT |
| aggregate functions: DISTINCT keyword and | Summarizing query results using aggregate functions |
| aggregate functions: GROUP BY clause | Using GROUP BY with aggregate functions |
| aggregate functions: NULL | Aggregate functions and NULL |
| aggregate functions: order by and group by | ORDER BY and GROUP BY |
| aggregate functions: outer references | Where you can use aggregate functions |
| aggregate functions: scalar aggregates | Where you can use aggregate functions |
| aggregate functions: vector aggregates | The GROUP BY clause: organizing query results into groups |
| aggregates: item in access plans | Reading access plans |
| aggregation functions: multiple levels | Typical applications of common table expressions |
| algorithms: for query execution | Query execution algorithms |
| aliases: about | Renaming columns in query results |
| aliases: correlation names | The FROM clause: specifying tables |
| ALL operator: about | The ALL test |
| ALL operator: notes | The ALL test |
| ALL: keyword and aggregate functions | Summarizing query results using aggregate functions |
| ALL: keyword and UNION clause | Combining sets with the UNION operation |
| ALL: subquery tests | The ALL test The ALL test |
| ALLOW_NULLS_BY_DEFAULT option: setting for Transact-SQL compatibility | Setting options for Transact-SQL compatibility |
| ALTER TABLE statement: and concurrency | Data definition statements and concurrency |
| ALTER TABLE statement: CHECK constraints | Using CHECK constraints on columns |
| ALTER TABLE statement: examples | Altering tables (SQL) |
| ALTER TABLE statement: foreign keys | Managing foreign keys (SQL) |
| ALTER TABLE statement: primary keys | Managing primary keys (SQL) |
| altering remote servers | Altering remote servers |
| altering: columns | Altering tables (Sybase Central) Altering tables (SQL) |
| altering: procedures | Altering procedures |
| altering: tables | Altering tables Altering tables (Sybase Central) Altering tables (SQL) |
| altering: triggers | Altering triggers |
| altering: views | Modifying views |
| always use a transaction log | Always use a transaction log |
| analysis: Index Consultant | Understanding the analysis |
| analysis: understanding | Understanding the analysis |
| analyzing workloads: Index Consultant | Index Consultant overview |
| AND: using logical operators | Connecting conditions with logical operators |
| ANSI compliance | Designing Your Database |
| ANSI update constraints: in access plans | Reading access plans |
| ANSI: non-ANSI joins | Non-ANSI joins |
| ANSI: SQL/92 standard and inconsistencies | Typical types of inconsistency |
| anti-insert: locks | Types of locks Locking during deletes |
| anti-semijoin: query execution algorithms | Hash antisemijoin |
| ANY operator: about | The ANY test |
| ANY operator: problems | The ANY test |
| ANY operator: subquery tests | The ANY test |
| apostrophes: character strings | Character strings and quotation marks |
| architecture: Adaptive Server | Adaptive Server architectures |
| arithmetic: expressions and operator precedence | Computing values in the SELECT list |
| arithmetic: operations | Summarizing query results using aggregate functions |
| AS keyword: aliases | Renaming columns in query results |
| asademo.db file: schema | Sample database schema |
| asajdbc server class | Server class asajdbc |
| asaodbc server class | Server class asaodbc |
| ascending order: ORDER BY clause | The ORDER BY clause: sorting query results |
| ASCII: format for importing and exporting | Data formats |
| asejdbc server class | Server class asejdbc |
| aseodbc server class | Server class aseodbc |
| assigning: data types to columns | Creating domains (Sybase Central) |
| assigning: domains to columns | Creating domains (Sybase Central) |
| assumptions affecting optimization | Underlying assumptions |
| asterisk (*): SELECT statement | Selecting all columns from a table |
| AT clause: CREATE EXISTING TABLE statement | Specifying proxy table locations |
| atomic compound statements | Atomic compound statements |
| atomic transactions | Introduction to transactions |
| attributes: choosing | Step 2: Identify the required data |
| attributes: definition of | Entities |
| attributes: SQLCA.lock | Setting the isolation level from an ODBC-enabled application |
| AUTO mode: using | Using FOR XML AUTO |
| autocommit: performance | Turn off autocommit mode |
| autocommit: transactions | Using transactions |
| AUTOINCREMENT: default | The AUTOINCREMENT default |
| autoincrement: IDENTITY column | The special IDENTITY column |
| AUTOINCREMENT: negative numbers | The AUTOINCREMENT default |
| AUTOINCREMENT: signed data types | The AUTOINCREMENT default |
| AUTOINCREMENT: UltraLite applications | The AUTOINCREMENT default |
| AUTOINCREMENT: when to use | Primary key generation |
| automatic joins: and foreign keys | Adaptive Server Anywhere SQL features |
| automatic performance tuning | Automatic performance tuning |
| automatic translation of stored procedures | Automatic translation of stored procedures |
| AUTOMATIC_TIMESTAMP option: setting for Transact-SQL compatibility | Setting options for Transact-SQL compatibility |
| automation: generating unique keys | Primary key generation |
| AvgDiskReads: estimate in access plans | Reading access plans |
| AvgDiskReadTime: estimate in access plans | Reading access plans |
| AvgDiskWrites: estimate in access plans | Reading access plans |
| AvgRowCount: estimate in access plans | Reading access plans |
| AvgRunTime: estimate in access plans | Reading access plans |