| page map: item in access plans | Reading access plans |
| page maps: scanning | Table and page sizes |
| page size: about | Table and page sizes |
| page size: and indexes | Table and page sizes |
| page size: disk allocation for inserted rows | Disk allocation for inserted rows |
| page size: performance | Use an appropriate page size |
| page sizes: and indexes | Recommended page sizes |
| pages: disk allocation for inserted rows | Disk allocation for inserted rows |
| parentheses: in arithmetic statements | Computing values in the SELECT list |
| parentheses: UNION operators | Combining sets with the UNION operation |
| partial index scan: about | Other uses for indexes |
| partial passthrough of the statement: remote data access | Partial passthrough of the statement |
| particular concurrency issues | Particular concurrency issues |
| parts explosion problems | Parts explosion problems |
| passing parameters to external functions | Passing parameters to external functions |
| passing parameters to functions | Passing parameters to functions |
| passing parameters to procedures | Passing parameters to procedures |
| passwords: case sensitivity | Case sensitivity |
| passwords: Lotus Notes | Lotus Notes SQL 2.0 |
| performance considerations for moving data | Performance considerations of moving data |
| Performance Monitor: adding and removing statistics | Adding and removing statistics |
| Performance Monitor: configuring | Configuring the Sybase Central Performance Monitor |
| Performance Monitor: opening in Sybase Central | Opening the Sybase Central Performance Monitor |
| Performance Monitor: overview | Monitoring database statistics from Sybase Central |
| Performance Monitor: running multiple copies | Monitoring database statistics from Windows Performance Monitor |
| Performance Monitor: setting the interval time | Configuring the Sybase Central Performance Monitor |
| Performance Monitor: starting | Monitoring database statistics from Windows Performance Monitor |
| Performance Monitor: Sybase Central | Monitoring database statistics from Sybase Central |
| Performance Monitor: Windows | Monitoring database statistics from Windows Performance Monitor |
| performance: about | Top performance tips |
| performance: autocommit | Turn off autocommit mode |
| performance: automatic tuning | Automatic performance tuning |
| performance: bulk loading | Performance considerations of moving data |
| performance: bulk operations | Use bulk operations methods |
| performance: cache | Increase the cache size |
| performance: cache read-hit ratio | Graphical plans |
| performance: comparing optimizer estimates and actual statistics | Graphical plans |
| performance: compression | Try using Adaptive Server Anywhere's compression features |
| performance: database design | Normalize your table structure |
| performance: estimate source | Graphical plans |
| performance: file fragmentation | Examine file, table, and index fragmentation File fragmentation |
| performance: file management | Place different files on different devices |
| performance: improving | Use indexes for frequently-searched columns Using clustered indexes |
| performance: improving versus locks | Reducing the impact of locking |
| performance: index fragmentation | Index fragmentation |
| performance: indexes | Working with indexes Use indexes effectively |
| performance: keys | Using keys to improve query performance |
| performance: measuring query speed | Monitoring query performance |
| performance: monitoring | Monitoring database performance |
| performance: monitoring in Windows | Monitoring database statistics from Windows Performance Monitor |
| performance: page size | Use an appropriate page size |
| performance: predicate analysis | Predicate analysis |
| performance: reading access plans | Reading access plans |
| performance: recommended page sizes | Recommended page sizes |
| performance: reducing requests | Reduce the number of requests between client and server |
| performance: runtime actuals and estimates | Graphical plans |
| performance: scattered reads | Use an appropriate page size |
| performance: selectivity | Graphical plans |
| performance: statistics in Windows Performance Monitor | Monitoring database statistics from Windows Performance Monitor |
| performance: table and page size | Table and page sizes |
| performance: table fragmentation | Table fragmentation |
| performance: tips | Top performance tips |
| performance: transaction log | Always use a transaction log |
| performance: WITH EXPRESS CHECK | Use the WITH EXPRESS CHECK option when validating tables |
| performance: work tables | Use of work tables in query processing |
| PerformanceFetch | Monitoring query performance |
| PerformanceInsert | Monitoring query performance |
| PerformanceTraceTime | Monitoring query performance |
| PerformanceTransaction | Monitoring query performance |
| permissions for data modification | Permissions for data modification |
| permissions: Adaptive Server Enterprise | Users and groups |
| permissions: data modification | Permissions for data modification |
| permissions: debugging | Requirements for using the debugger |
| permissions: procedure result sets | Returning result sets from procedures |
| permissions: procedures calling external functions | Creating procedures and functions with external calls |
| permissions: triggers | Trigger execution permissions |
| permissions: user-defined functions | Permissions to execute user-defined functions |
| phantom locks | Practical locking implications tutorial |
| phantom rows: tutorial | Phantom row tutorial |
| phantom rows: versus isolation levels | Typical types of inconsistency Practical locking implications tutorial Two-phase locking |
| phantom: rows | Typical types of inconsistency Locking during queries Two-phase locking |
| physical data model: generating | Step 4: Resolve the relationships |
| physical data organization | Physical data organization and access |
| place different files on different devices | Place different files on different devices |
| plans: abbreviations used in | Reading access plans |
| plans: caching of | Access plan caching |
| plans: context sensitive help | Graphical plans |
| plans: customizing | Graphical plans |
| plans: graphical plans | Graphical plans |
| plans: Interactive SQL | Accessing the plan |
| plans: long text plans | Text plans |
| plans: printing | Graphical plans |
| plans: reading | Reading access plans |
| plans: short text plans | Text plans |
| plans: SQL functions | Accessing the plan |
| plus operator: NULL values | Properties of NULL |
| portable computers: replicating databases | Replication and concurrency |
| portable SQL | General guidelines for writing portable SQL |
| PowerBuilder: remote data access | Accessing remote data from PowerBuilder DataWindows |
| practical locking implications tutorial | Practical locking implications tutorial |
| predicate analysis: about | Predicate analysis |
| predicate pushdown into grouped or unioned views | Predicate pushdown into GROUPed or UNION views |
| predicates: about | Predicate analysis |
| predicates: item in access plans | Reading access plans |
| predicates: performance | Predicate analysis |
| predicates: reading in access plans | Graphical plans |
| prefix columns: ROLLUP operation | The ROLLUP operation: adding summary information to GROUP BY queries |
| prefixes: ROLLUP operation | The ROLLUP operation: adding summary information to GROUP BY queries |
| prefixes: subtotal rows | The ROLLUP operation: adding summary information to GROUP BY queries |
| PREPARE statement: remote data access | Remote transaction management overview |
| preserved tables: in outer joins | Outer joins |
| primary keys enforce entity integrity | Primary keys enforce entity integrity |
| primary keys: and integrity | Adaptive Server Anywhere SQL features |
| primary keys: AUTOINCREMENT | The AUTOINCREMENT default |
| primary keys: concurrency | Particular concurrency issues |
| primary keys: creating | Managing primary keys (Sybase Central) Managing primary keys (SQL) |
| primary keys: entity integrity | Primary keys enforce entity integrity |
| primary keys: generation | Primary key generation |
| primary keys: managing | Managing primary keys |
| primary keys: modifying | Managing primary keys (Sybase Central) Managing primary keys (SQL) |
| primary keys: performance | Using keys to improve query performance |
| primary keys: using NEWID to create UUIDs | The NEWID default |
| procedure creation wizard: about | Creating procedures |
| procedure creation wizard: using | Creating procedures |
| procedure language: overview | Transact-SQL procedure language overview |
| procedure profiling: clearing in Sybase Central | Disabling procedure profiling |
| procedure profiling: clearing with SQL | Disabling procedure profiling |
| procedure profiling: disabling in Sybase Central | Disabling procedure profiling |
| procedure profiling: disabling with SQL | Disabling procedure profiling |
| procedure profiling: enabling in Sybase Central | Enabling procedure profiling |
| procedure profiling: enabling with SQL | Enabling procedure profiling |
| procedure profiling: events | Viewing procedure profiling information in Sybase Central Viewing profiling information for a specific procedure |
| procedure profiling: information for individual procedures | Viewing profiling information for a specific procedure Viewing profiling information for a specific procedure in Interactive SQL |
| procedure profiling: resetting in Sybase Central | Resetting procedure profiling |
| procedure profiling: resetting with SQL | Resetting procedure profiling |
| procedure profiling: stored procedures and functions | Viewing procedure profiling information in Sybase Central Viewing profiling information for a specific procedure |
| procedure profiling: summary data | Viewing procedure profiling information in Sybase Central |
| procedure profiling: summary of procedures | Viewing procedure profiling information in Interactive SQL |
| procedure profiling: triggers | Viewing procedure profiling information in Sybase Central Viewing profiling information for a specific procedure |
| procedure profiling: viewing data in Interactive SQL | Viewing procedure profiling information in Interactive SQL |
| procedure profiling: viewing data in Sybase Central | Profiling database procedures Viewing procedure profiling information in Sybase Central |
| procedures: about | Using Procedures, Triggers, and Batches |
| procedures: adding remote procedures | Creating remote procedures |
| procedures: altering | Altering procedures |
| procedures: benefits of | Benefits of procedures and triggers |
| procedures: calling | Calling procedures |
| procedures: command delimiter | Check if you need to change the command delimiter |
| procedures: copying | Copying procedures in Sybase Central |
| procedures: creating | Creating procedures |
| procedures: cursors | Using cursors in procedures and triggers |
| procedures: dates | Specifying dates and times in procedures |
| procedures: default error handling | Default error handling in procedures and triggers |
| procedures: deleting | Deleting procedures |
| procedures: deleting remote procedures | Dropping remote procedures |
| procedures: error handling | Error handling in Transact-SQL procedures Transact-SQL-like error handling in the Watcom-SQL dialect Errors and warnings in procedures and triggers |
| procedures: exception handlers | Using exception handlers in procedures and triggers |
| procedures: EXECUTE IMMEDIATE statement | Using the EXECUTE IMMEDIATE statement in procedures |
| procedures: external functions | Calling external libraries from procedures |
| procedures: multiple result sets from | Returning multiple result sets from procedures |
| procedures: overview | Procedure and trigger overview |
| procedures: parameters | Declaring parameters for procedures Passing parameters to procedures |
| procedures: permissions for result sets | Returning result sets from procedures |
| procedures: result sets | Returning procedure results in result sets Returning result sets from procedures |
| procedures: return values | Error handling in Transact-SQL procedures |
| procedures: returning results | Returning results from procedures Returning results as procedure parameters |
| procedures: returning results from | Returning procedure results in parameters |
| procedures: savepoints | Transactions and savepoints in procedures and triggers |
| procedures: security | Benefits of procedures and triggers |
| procedures: SQL statements allowed | SQL statements allowed in procedures and triggers |
| procedures: structure | The structure of procedures and triggers |
| procedures: table names | Use fully-qualified names for tables in procedures |
| procedures: times | Specifying dates and times in procedures |
| procedures: tips for writing | Tips for writing procedures |
| procedures: Transact-SQL | Automatic translation of stored procedures |
| procedures: Transact-SQL overview | Transact-SQL stored procedure overview |
| procedures: translation | Automatic translation of stored procedures |
| procedures: using | Introduction to procedures |
| procedures: using cursors in | Using cursors on SELECT statements in procedures |
| procedures: using in the FROM clause | The FROM clause: specifying tables |
| procedures: variable result sets from | Returning variable result sets from procedures |
| procedures: verifying input | Verifying that procedure input arguments are passed correctly |
| procedures: warnings | Default handling of warnings in procedures and triggers |
| profiling database procedures | Profiling database procedures |
| profiling information: events | Viewing profiling information for a specific procedure |
| profiling information: stored procedures and functions | Viewing profiling information for a specific procedure |
| profiling information: triggers | Viewing profiling information for a specific procedure |
| program variables: in common table expression | Typical applications of common table expressions |
| properties of NULL | Properties of NULL |
| properties: setting all database object properties | Setting properties for database objects |
| PROPERTY function: about | Obtaining database statistics from a client application |
| property sheets | Setting properties for database objects |
| property: definition of | Entities |
| protocols: two-phase locking | Two-phase locking |
| prototypes: external functions | External function prototypes |
| proxy table creation wizard: using | Creating proxy tables (Sybase Central) |
| proxy tables: about | Remote table mappings Working with proxy tables |
| proxy tables: location | Specifying proxy table locations |
| publications: data replication and concurrency | Replication and concurrency |