Gregory Maxwell <[EMAIL PROTECTED]> wrote: > The flipside there is that a good set of hinting options may increase > the amount of detailed feedback we get from users on improvements > needed in the optimizer. The current knobs are pretty blunt and don't > do as much as I'd like when trying to track down exactly where the > optimiser has gone wrong.
Point conceded. Any information that can help diagnose an issue is good information. I like the idea of only allowing it on explain. Mike Pollard SUPRA Server SQL Engineering and Support Cincom Systems, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match