Looks simple but …

(open images in a new window to see full size)

I’m really enjoying DB Optimizers simple drill down into SQL statements that hide complexity, for example this query looks pretty simple:

but a simple double click into “BIG_STATEMENT2” shows me what’s really going on: