Index
Page numbers followed by f indicates a figure and t indicates a table.
A
ABSOLUTE fetch, 102
Access control language, 3
Access methods
bit vector indexes, 740
hashed indexes, 739
indexed access, 739
sequential access, 738
ADD clause, 81
ADD COLUMN clause, 80
Adjacency list model
adjacency matrix model, 691–693
complex constraints
CHECK( ), 667
nodes, , 682682f
nonacyclic graphs, 689–691
paths with CTE, 684–689
procedural traversal for queries, 669–670
SQL and, 683–684
table alteration, 670
Adjacency matrix model, 691–693
AFTER trigger, 125
Aftermath, 735–736
AGE( ) function, 717
OUTER JOINs and, 424
in SELECT clause, 404
Algorithms
ascending order, 438
Get Joe Celko's SQL for Smarties, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
