Hi everyone,
My client's database has a form whose datasource is a maze of dozens of interlinked queries, and naturally the thing is crushingly slow to run. (I didn't design this thing!)
Now one particular bottleneck I think I've discovered, is a Union query which stacks ten separate queries...