On Tue, Jul 19, 2005 at 10:23:49PM +0100, Simon Riggs wrote: > Inheritance queries would continue to act as they do now, where an > excluded table is *not* shown; this is to allow for sensible size > EXPLAINs when we have 100s of child tables.
Since it's also possible to do partitioning with UNION ALL, maybe it would be better if there was an option to explain that told it either to show or not show info about eliminated partitions. That would seem to serve the general case better than coding it according to table type. -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
