A request for information from the database based on specific conditions, such as a request for a list of all customers in a customer table whose balance is greater than $1,000.
A set of query rewrite rules and optimization techniques for compiling queries.
A component of the SQL compiler that chooses an access plan for a data manipulation language statement by modeling the execution cost of many alternative access plans and choosing the one with the minimum estimated cost.
To end a process by allowing operations to complete normally while rejecting any new requests for work.
A point at which data is consistent as a result of running the DB2 UDB QUIESCE utility.