| I/O: scanning bitmaps | Table and page sizes |
| IBM DB2: migrating to Adaptive Server Anywhere | Migrating databases to Adaptive Server Anywhere |
| IBM DB2: remote data access to DB2 | Server class db2odbc |
| icons: used in manuals | Documentation conventions |
| idempotent functions: defined | Subquery and function caching |
| identifiers: case sensitivity | Case sensitivity |
| identifiers: qualifying | SQL queries |
| identifiers: uniqueness | Ensuring compatible object names |
| identifiers: using in domains | Creating domains (SQL) |
| identifying entities and relationships | Step 1: Identify entities and relationships |
| IDENTITY column | The special IDENTITY column |
| IDENTITY column: retrieving values | Retrieving IDENTITY column values with @@identity |
| if a client application breaches entity integrity | If a client application breaches entity integrity |
| if a client application breaches referential integrity | If a client application breaches referential integrity |
| IF statement: syntax | Control statements |
| images: inserting | Inserting documents and images |
| implementation of locking | Two-phase locking |
| implementing recommendations: Index Consultant | Implementing the recommendations |
| import tools | Import tools |
| import wizard: about | Import tools |
| import wizard: using | Importing data |
| importing and exporting data | Importing and Exporting Data |
| importing data: about | Introduction to import and export |
| importing data: conversion errors | Conversion errors during import |
| importing data: DEFAULTS option | Table structures for import |
| importing data: from other databases | Import tools |
| importing data: interactively | Importing data |
| importing data: LOAD TABLE statement | Importing a table |
| importing data: performance | Performance considerations of moving data |
| importing data: proxy tables | Import tools |
| importing data: temporary tables | Table structures for import Table structures for import |
| importing data: tools | Import tools |
| importing XML documents as relational data | Importing XML documents as relational data |
| importing XML using OPENXML | Importing XML using OPENXML |
| importing XML using the DataSet object | Importing XML using the DataSet object |
| importing: Adaptive Server Enterprise compatibility | Adaptive Server Enterprise compatibility |
| importing: databases | Importing databases |
| importing: file formats | Data formats |
| importing: introduction | Importing and exporting data |
| importing: non-matching table structures | Table structures for import |
| importing: NULL values | Table structures for import |
| importing: tools | Import tools |
| importing: using temporary tables | Working with temporary tables |
| improving concurrency at isolation levels 2 and 3 | Improving concurrency at isolation levels 2 and 3 |
| improving index performance | Improving index performance |
| improving performance | Top performance tips |
| IN conditions: subqueries | Testing set membership with IN conditions |
| IN keyword: matching lists | Using lists in the WHERE clause |
| IN list: algorithm | IN list |
| IN list: item in access plans | Reading access plans |
| IN list: optimization | IN-list optimization |
| IN parameters: defined | Declaring parameters for procedures |
| inconsistencies non-repeatable reads | Typical types of inconsistency Non-repeatable read tutorial Locking during queries |
| inconsistencies: avoiding using locks | How locking works |
| inconsistencies: dirty reads | Typical types of inconsistency Locking during queries |
| inconsistencies: dirty reads tutorial | Dirty read tutorial |
| inconsistencies: effects of unserializable schedules | Serializable schedules |
| inconsistencies: example of non-repeatable read | Non-repeatable read tutorial |
| inconsistencies: ISO SQL/92 standard | Typical types of inconsistency |
| inconsistencies: phantom rows | Typical types of inconsistency Phantom row tutorial Locking during queries Two-phase locking |
| inconsistencies: practical locking implications | Practical locking implications tutorial |
| increase the cache size | Increase the cache size |
| IndAdd: statistic in access plans | Reading access plans |
| Index Consultant: about | Starting the Index Consultant |
| Index Consultant: assessing recommendations | Assessing the recommendations |
| Index Consultant: connection state | Assessing the recommendations |
| Index Consultant: implementing recommendations | Implementing the recommendations |
| Index Consultant: introduction | Choosing a set of indexes Index Consultant |
| Index Consultant: recommendations | Understanding the recommendations |
| Index Consultant: server state | Assessing the recommendations |
| Index Consultant: starting | Starting the Index Consultant |
| Index Consultant: stopping | Stopping the Index Consultant |
| Index Consultant: understanding | Index Consultant overview Understanding the Index Consultant |
| Index Consultant: workloads | Index Consultant overview Understanding workloads |
| index creation wizard: using | Creating indexes |
| index fragmentation | Index fragmentation |
| index scans: about | Index scans |
| index selectivity: about | Improving index performance |
| indexed distinct: query execution algorithms | Indexed distinct |
| indexed group by: query execution algorithms | Indexed group by |
| indexes in the system tables | Indexes in the system tables |
| indexes: about | Indexes |
| indexes: assistance | Index Consultant |
| indexes: B-tree | Types of index |
| indexes: benefits | Index Consultant overview |
| indexes: benefits and locking | Reducing the impact of locking |
| indexes: can usually be found to satisfy a predicate | An index can usually be found to satisfy a predicate |
| indexes: candidate | Index Consultant overview |
| indexes: clustered | Using clustered indexes |
| indexes: composite | Composite indexes Hash B-tree indexes |
| indexes: compressed B-tree | Compressed B-tree indexes |
| indexes: correlations between | Assessing the recommendations |
| indexes: costs | Index Consultant overview |
| indexes: creating | Creating indexes |
| indexes: deleting | Dropping indexes |
| indexes: effect of column order | Composite indexes |
| indexes: fan-out and page sizes | Recommended page sizes |
| indexes: fragmentation | Index fragmentation |
| indexes: frequently-searched columns | Use indexes for frequently-searched columns |
| indexes: hash B-tree | Hash B-tree indexes |
| indexes: hash values | Hash B-tree indexes |
| indexes: HAVING clause performance | Predicate analysis |
| indexes: improving concurrency | Special optimizations |
| indexes: Index Consultant | Choosing a set of indexes Index Consultant overview Starting the Index Consultant |
| indexes: inspecting | Indexes in the system tables |
| indexes: leaf pages | Improving index performance |
| indexes: optimization and | Indexes |
| indexes: performance | Normalize your table structure Use indexes effectively |
| indexes: predicate analysis | Predicate analysis |
| indexes: recommended page sizes | Recommended page sizes |
| indexes: sargable predicates | Predicate analysis |
| indexes: structure | Improving index performance |
| indexes: temporary tables | When to create an index |
| indexes: Transact-SQL | Ensuring compatible object names |
| indexes: types of index | Types of index |
| indexes: understanding the Index Consultant | Understanding the Index Consultant |
| indexes: unused | Understanding the recommendations |
| indexes: validating | Validating indexes |
| indexes: virtual | Index Consultant overview |
| indexes: when to use | When to use indexes |
| indexes: WHERE clause performance | Predicate analysis |
| indexes: working with | Working with indexes |
| indexes:: computed columns | Creating indexes |
| IndLookup: statistic in access plans | Reading access plans |
| initial cache size | Limiting the memory used by the cache |
| initialization utility: using | Creating databases (command line) |
| inner and outer joins | Inner and outer joins |
| inner joins: about | Inner joins |
| INOUT parameters: defined | Declaring parameters for procedures |
| INPUT statement: about | Import tools |
| INPUT statement: using | Importing data |
| inputting: import tools | Import tools |
| inputting: importing data | Importing and exporting data Importing data |
| inputting: importing databases | Importing databases |
| inputting: importing tables | Importing a table |
| INSERT statement: about | Adding data using INSERT Import tools |
| INSERT statement: locking during | Locking during inserts |
| INSERT statement: SELECT | Adding data using INSERT |
| INSERT statement: using | Importing data |
| inserting data: adding NULL | Inserting values into specific columns |
| inserting data: BLOBs | Inserting documents and images |
| inserting data: column data INSERT statement | Inserting values into specific columns |
| inserting data: constraints | Inserting values into specific columns |
| inserting data: defaults | Inserting values into specific columns |
| inserting data: into all columns | Inserting values into all columns of a row |
| inserting data: using INSERT | Adding data using INSERT |
| inserting data: with SELECT | Adding new rows with SELECT |
| inserting documents and images | Inserting documents and images |
| inserting values into all columns of a row | Inserting values into all columns of a row |
| inserting values into specific columns | Inserting values into specific columns |
| installing: jConnect metadata support | Installing the jConnect metadata support to an existing database |
| instest | Monitoring query performance |
| integrity constraints belong in the database | Integrity constraints belong in the database |
| integrity rules in the system tables | Integrity rules in the system tables |
| integrity: about | Data integrity overview |
| integrity: checking | Referential integrity checking |
| integrity: column defaults | Using column defaults |
| integrity: constraints | SQL statements for implementing integrity constraints Using table and column constraints |
| integrity: enforcing | Enforcing entity and referential integrity |
| integrity: information in the system tables | Integrity rules in the system tables |
| integrity: losing | Losing referential integrity |
| integrity: tools | Data integrity tools |
| integrity: using triggers to maintain | Data integrity tools |
| Interactive SQL import wizard: about | Import tools |
| Interactive SQL: batch operations | Saving, loading, and running command files |
| Interactive SQL: command delimiter | Check if you need to change the command delimiter |
| Interactive SQL: command files | Running SQL command files |
| Interactive SQL: exporting query results | Exporting query results |
| Interactive SQL: exporting relational data as XML | Exporting relational data as XML from Interactive SQL |
| Interactive SQL: loading commands | Saving, loading, and running command files |
| Interactive SQL: rebuilding databases | Rebuild tools |
| Interactive SQL: running scripts | Saving, loading, and running command files |
| Interactive SQL: saving commands | Saving, loading, and running command files |
| interference between transactions | Transaction blocking Non-repeatable read tutorial |
| interleaving transactions | Serializable schedules |
| internal loading | Performance considerations of moving data |
| internal operations: remote data access | Internal operations |
| interrupt: Run menu | Working with breakpoints |
| INTERSECT operation: combining queries | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
| INTERSECT operation: NULL | Set operators and NULL |
| INTERSECT operation: rules | Rules for set operations |
| INTERSECT operation: using | Using EXCEPT and INTERSECT |
| INTO clause: using | Returning results as procedure parameters |
| invalid data | How data can become invalid |
| invocations: statistic in access plans | Reading access plans |
| IS NULL keyword | Properties of NULL |
| ISNULL function: about | Properties of NULL |
| ISO compliance | Designing Your Database |
| ISO SQL/92 standard: concurrency | Typical types of inconsistency |
| ISO SQL/92 standard: typical inconsistencies and | Typical types of inconsistency |
| isolation level 0: example | Dirty read tutorial |
| isolation level 0: SELECT statement locking | Locking during queries |
| isolation level 1: example | Non-repeatable read tutorial |
| isolation level 1: SELECT statement locking | Locking during queries |
| isolation level 2: example | Phantom row tutorial Practical locking implications tutorial |
| isolation level 2: SELECT statement locking | Locking during queries |
| isolation level 3: example | Phantom row tutorial |
| isolation level 3: SELECT statement locking | Locking during queries |
| isolation levels and consistency | Isolation levels and consistency |
| isolation levels: about | Isolation levels and consistency |
| isolation levels: changing within a transaction | Changing isolation levels within a transaction |
| isolation levels: choosing | Choosing isolation levels |
| isolation levels: choosing types of locking tutorial | Non-repeatable read tutorial |
| isolation levels: implementation at level 0 | Locking during queries |
| isolation levels: implementation at level 1 | Locking during queries |
| isolation levels: implementation at level 2 | Locking during queries |
| isolation levels: implementation at level 3 | Locking during queries |
| isolation levels: improving concurrency at levels 2 and 3 | Improving concurrency at isolation levels 2 and 3 |
| isolation levels: ODBC | Setting the isolation level from an ODBC-enabled application |
| isolation levels: setting | Setting the isolation level |
| isolation levels: tutorials | Isolation level tutorials |
| isolation levels: typical transactions for each | Typical transactions at various isolation levels |
| isolation levels: versus typical inconsistencies | Typical types of inconsistency Phantom row tutorial Practical locking implications tutorial Two-phase locking |
| isolation levels: versus typical transactions | Typical transactions at various isolation levels |
| isolation levels: viewing | Viewing the isolation level |