Subject Re: [firebird-support] SQL Question
Author Ann W. Harrison
Michael Vilhelmsen wrote:
> An SQL statement like the below, will it make 4 sub selects for each
> record in table VD ?

> If Yes - Can it be modified to only make one select for each record ?

No, but don't worry. Since the conditions are identical, after the
first subselect, all pages (index, pointer, & data) will be in cache and
the performance will be excellent, despite the ugliness of the code.