[link|http://dev.mysql.com/doc/refman/5.1/en/mysql-nutshell.html|http://dev.mysql.com...sql-nutshell.html]

The only thing referenced is the partitioning and that doesn't help the initial poor SQL optimization for the straight selects of smallish tables.

I think I'm expecting too much since I have my Oracle experience.