Index_L

L

leaf blocks, defined, 244, 244

least recently used (LRU) algorithm, 164

left outer joins, 109

LGWR. See Log Writer (LGWR)

Like operator, and WHERE clause, 76, 80–81

LINESIZE system variable, 183

list partitioning, 252

Log Miner, 282–284, 283–284

Log Writer (LGWR), 163, 165–166

logical consistency, 141–155

constraints, 141, 142–151

basics of, 142

CHECK, 144–146

FOREIGN KEY, 149–151

NOT NULL, 142–143

PRIMARY KEY, 147–149

UNIQUE, 146–147

transaction processing, 151–154

COMMIT statement, 152–153, 153

ROLLBACK statement, 153–154

SAVEPOINT statement, 154

logical storage structures, 158–160, 158, 161

LRU (least recently used) algorithm, 164