On Tue, Nov 24, 2009 at 7:57 PM, Domas Mituzas
<midom.lists(a)gmail.com> wrote:
Antony writes:
If it is, you'd probably want to use
partitioning
Partitioning makes selects faster only when there's parallel execution
on multiple partitions at once.
[snip]
I have no idea how this works on MySQL, or if it works on MySQL at
all. In MySQL, you could achieve the same thing through clustering,
however.
"When the optimizer can make use of partition pruning in performing a
query, execution of the query can be an order of magnitude faster than
the same query against a nonpartitioned table containing the same
column definitions and data. "
I don't see any mention of "parallel execution", and I don't see why
that would be necessary to benefit from partitioning.