[grumpydba]

> I know what I want the optimizer to do

For a cute little select statement, it might be true. However it's just not manageable most of the time.