Posted by bbla32 on 02/19/07 23:01

On Feb 19, 11:33 pm, Roy Harvey <roy_har...@snet.net> wrote:
> Assuming I didn't make a mistake - the code is untested of course -
> the following might perform slightly better. Or not, a lot depends on
> the indexing and actual data.

Great example!


> as an EXISTS test. In any case the use of subqueries in the CASE
> should limit the number of times the subqueries are executed, which is
> where any performance gain will come from.

Well, wouldn't it execute slower since the subquery is within CASE?
I have indices only on ID columns for all tables.

[Back to original message]