
| early release of locks | Typical transactions at various isolation levels Two-phase locking |
| early release of locks: an exception | Early release of read locks |
| editing breakpoint conditions | Editing breakpoint conditions |
| editing: properties of database objects | Setting properties for database objects |
| editing: table data | Browsing the information in tables |
| effects of: transaction scheduling | Serializable schedules |
| effects of: unserializable transaction scheduling | Serializable schedules |
| efficiency: improving and locks | Reducing the impact of locking |
| efficiency: improving using indexes | Special optimizations |
| element directive: using | Using FOR XML EXPLICIT |
| eliminating duplicate query results | Eliminating duplicate query results |
| elimination of unnecessary case translation | Elimination of unnecessary case translation |
| enabling breakpoints | Disabling and enabling breakpoints |
| enabling procedure profiling: SQL | Enabling procedure profiling |
| enabling procedure profiling: Sybase Central | Enabling procedure profiling |
| encryption: cache size | Increase the cache size |
| encryption: hiding objects | Hiding the contents of procedures, functions, triggers and views |
| ending transactions | Using transactions |
| enforcing column uniqueness | Other uses for indexes |
| enforcing entity and referential integrity | Enforcing entity and referential integrity |
| enforcing referential integrity | Enforcing referential integrity |
| ensuring compatible object names | Ensuring compatible object names |
| ensuring data integrity | Ensuring Data Integrity |
| entities: about | Entities |
| entities: attributes | Entities |
| entities: choosing | Step 1: Identify entities and relationships |
| entities: definition of | Database design concepts |
| entities: forcing integrity | Enforcing entity and referential integrity |
| entity integrity | Adaptive Server Anywhere SQL features |
| entity integrity: breached by client application | If a client application breaches entity integrity |
| entity integrity: introduction | Data integrity tools |
| entity-relationship diagrams: about | Database design concepts |
| entity-relationship diagrams: reading | Relationships |
| equals operator: comparison operator | Using comparison operators in the WHERE clause |
| equijoins: about | Types of explicit join conditions |
| erase database wizard: using | Erasing a database |
| erase utility: using | Erasing a database |
| erasing databases | Erasing a database |
| error handling in Transact-SQL procedures | Error handling in Transact-SQL procedures |
| error handling: ON EXCEPTION RESUME | Error handling with ON EXCEPTION RESUME |
| error handling: procedures and triggers | Default error handling in procedures and triggers |
| errors and warnings in procedures and triggers | Errors and warnings in procedures and triggers |
| errors: conversion | Conversion errors during import |
| errors: procedures and triggers | Errors and warnings in procedures and triggers |
| errors: Transact-SQL | Error handling in Transact-SQL procedures Transact-SQL-like error handling in the Watcom-SQL dialect |
| EstCpuTime: estimate in access plans | Reading access plans |
| EstDiskReads: estimate in access plans | Reading access plans |
| EstDiskReadTime: estimate in access plans | Reading access plans |
| EstDiskWrites: estimate in access plans | Reading access plans |
| estimated leaf pages: item in access plans | Reading access plans |
| estimated pages: item in access plans | Reading access plans |
| estimated row size: item in access plans | Reading access plans |
| estimated rows: item in access plans | Reading access plans |
| EstRowCount: estimate in access plans | Reading access plans |
| EstRunTime: estimate in access plans | Reading access plans |
| events: viewing individual profiling information | Viewing profiling information for a specific procedure |
| events: viewing summary profiling data | Viewing procedure profiling information in Sybase Central |
| examining variables: debugger | Working with variables |
| examples: dirty reads | Dirty read tutorial |
| examples: implications of locking | Practical locking implications tutorial |
| examples: non-repeatable read | Non-repeatable read tutorial |
| examples: non-repeatable reads | Non-repeatable read tutorial |
| examples: phantom locks | Practical locking implications tutorial |
| examples: phantom rows | Phantom row tutorial |
| Excel and remote access | Microsoft Excel (Microsoft 3.51.171300) |
| EXCEPT operation: combining queries | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| EXCEPT operation: NULL | Set operators and NULL |
| EXCEPT operation: rules | Rules for set operations |
| EXCEPT operation: using | Using EXCEPT and INTERSECT |
| exception handlers: nested compound statements | Nested compound statements and exception handlers |
| exception handlers: procedures and triggers | Using exception handlers in procedures and triggers |
| exceptions: declaring | Default error handling in procedures and triggers |
| exclusive locks | Types of locks |
| exclusive versus shared locks | Types of locks |
| EXECUTE IMMEDIATE statement: procedures | Using the EXECUTE IMMEDIATE statement in procedures |
| executing triggers | Executing triggers |
| existence test: about | Existence test Existence test |
| existence test: negation of | Existence test |
| EXISTS operator | Existence test |
| EXISTS predicates: rewriting subqueries as | Rewriting subqueries as EXISTS predicates |
| explicit join conditions | Join conditions |
| explicit join conditions (the ON phrase) | Explicit join conditions (the ON phrase) |
| EXPLICIT mode: syntax | Using FOR XML EXPLICIT |
| EXPLICIT mode: using | Using FOR XML EXPLICIT |
| EXPLICIT mode: using the cdata directive | Using FOR XML EXPLICIT |
| EXPLICIT mode: using the element directive | Using FOR XML EXPLICIT |
| EXPLICIT mode: using the hide directive | Using FOR XML EXPLICIT |
| EXPLICIT mode: using the xml directive | Using FOR XML EXPLICIT |
| EXPLICIT mode: writing queries | Using FOR XML EXPLICIT |
| explode: query execution algorithms | Explode |
| export tools | Export tools |
| exporting data: about | Introduction to import and export |
| exporting data: schema | Exporting table data or table schema |
| exporting data: tools | Export tools |
| exporting databases: using | Exporting databases |
| exporting relational data as XML | Exporting relational data as XML |
| exporting relational data as XML from Interactive SQL | Exporting relational data as XML from Interactive SQL |
| exporting relational data as XML using the DataSet object | Exporting relational data as XML using the DataSet object |
| exporting tables: schema | Exporting table data or table schema |
| exporting: Adaptive Server Enterprise compatibility | Adaptive Server Enterprise compatibility |
| exporting: file formats | Data formats |
| exporting: introduction | Importing and exporting data |
| exporting: NULL values | Outputting NULLs |
| exporting: query results | Exporting query results |
| exporting: schema | Exporting table data or table schema |
| exporting: tables | Exporting tables |
| expression SQL: item in access plans | Reading access plans |
| expressions: NULL values | Properties of NULL |
| external calls: creating procedures and functions | Creating procedures and functions with external calls |
| external functions: canceling | External function prototypes |
| external functions: passing parameters | Passing parameters to external functions |
| external functions: prototypes | External function prototypes |
| external functions: return types | Passing parameters to external functions |
| external loading | Performance considerations of moving data |
| external logins: about | Working with external logins |
| external logins: creating | Creating external logins |
| external logins: dropping | Dropping external logins |
| external servers: ODBC | Defining ODBC external servers |
| extract database wizard: about | Extracting data |
| extracting: databases for SQL Remote | Extracting data |