>A 'nooptimize' option per clause expression is a good idea too.
I don't like the NOOPTIMIZE option: what I am striving for (in many cases) is PARTIAL optimization. No R.Optimization would mean that ALL RECORDS have to be retrieved, whereas Full R.O. would mean (in some cases) retrieving almost all INDEX KEYS. With Partial R.O., both things can be avoided. In some cases, at least.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)