I

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

I/Os (increased), relieving over-worked CPUs
@@IDENTITY system variable (Transact-SQL)
implicit constraints on data
implicit rules
implicit type conversions
     indexes and
inconsistency of data 2nd
incorrect results, difficulty of spotting
indeterminate condition
index range scan
index-organized tables (IOTs)
     drawbacks of
     forcing row ordering
     solving contention problems with
indexes
     adding to DMBS to tune it
     as data repositories
         full table scans vs.
         storing maximum data possible
     bitmap
     clustered vs. non-clustered index performance
     completing queries with data returned from
     content lists and
     contention within, improving
     correlated subqueries and
     costs of
     costs of maintaining
     data access at atomic level of granularity
     data loading and
     data warehousing
     defining row order in tables
     dimension tables
     dimensional model
     finding physical location of a row
     foreign keys and
     maintenance costs
     making them work
         location of rows associated with index key
     multiple indexing of a column
     necessity of using, despite costs
     optimizer and
     partitioning
     performance and
     physical design of
     production database tuning and
     proportions of retrieved data
     queries returning small result set from very specific criteria
         criterion indexability
         data dispersion
         index usability
         query efficiency and index usage
     reference to disk addresses
     reverse
         solving contention problems
     searching
     system-generated keys
     temporary tables
     transactional databases
     variability of accesses
     virtues of
     with functions 2nd
         implicit conversions and
indirect criterion
ingredients, identifying
     names and proportions in various products
inline views
     rewriting uncorrelated subqueries as
     rewriting uncorrelated subqueries as joins in
Inmon, Bill
inner queries
input, primitive
insensitivity to volume increases
insert statements
     dynamic, built for varying table names
     returning ... into ... clause
insertion rates
     obtained with contention-limiting measures
     regular table vs. index-organized table
insertions
     contention and
     into referencing tables, preventing
     ranking in terms of overall cost
integrity checking, taken out of DBMS kernel
integrity constraints
     data loading and
     foreign key constraint in master/detail relationship
     partitioned view and
     validation performed through
inter-process communications, caused by use of procedural logic
inter-process database link
intersect operator
intersection of result sets
     final result set, small intersection of broad criteria
     intermediate result sets
IP address database link