> The question is, does MySQL's optimiser do enough planing to result in a
> tree of any non-trivial interest?
I don't know - apparently, you think it doesn't?
> I love MySQL as much as the next geek with a significant other that
> loves dolphins, but I'm not sure that MySQL 4.0 would provide a lot of
> data for funky tree-drawing (MS SQL tool style).
That was the idea ;-)
> Anyone have any comments regarding the optimiser improvements in MySQL 5?
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL