|< < 24 > >|

Rearranging Relational Algebra Expressions

Can the select be done before the join?

  • Yes.

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])

|< < 24 > >|