Hi, Does MySQL offering a similar functionality as Oracle does with table partitioning?
Oracle can split a table into several pieces where the pieces are - usually - identified by a range of valus. For example, one may split a table holding data on a daily basis into monthly partitions. Oracle will store the data in the partition identified by month of the new inserted data. As the tablespace used by each partition can be specified this is very usefull to spread the disk IO to several harddisks. The main reason for partitioning a table is to make VERY large tables more performant. Oracle fetches only the partions needed by the SQL statement, this means a full table scan will only process partitions identified by the WHERE clause and not the full range of data. If MySQL does not offer this or a simmilar functionality, how does MySQL perform on very large tables (I'm talking here about 10 Gigs+ of data stored in a single fact table)? Best Regards, Wolfgang --------------------------------------------------------------------- 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
