Indexing Join Inputs for Fast Queries and Maintenance

Wenhui Lyu, Goetz Graefe

In database systems, joins are often expensive despite many years of research producing numerous join algorithms. Precomputed and materialized join views deliver the best query per…