> I've recently learned that Oracle has the ability to partition table > data, Oracle9i's list partitioning feature.
> http://www.oracle.com/oramag/oracle/02-jan/index.html?o12part.html > I'm trying to find out if MySQL or any open source database has > something equivalent to this. See the MySQL MERGE TABLE type - http://www.mysql.com/doc/en/MERGE.html You have to allocate inserts to different "partitions" in your application, but you can merge many partition tables into one for the purpose of SELECT, DELETE, and UPDATE. Alec --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php