Rearranging Relational Algebra Expressions
Can the select be done before the join?
A faster version of the query
What are the titles of albums by The Detroit Cobras?
Original:
project(
select(
join(Artist, Album),
name == 'The Detroit Cobras')
[title])
Rewritten:
project(
join(
select(Artist, name == 'The Detroit Cobras'),
Album),
[title])
|