Re: webmail user mailbox schema design?
Date: Fri, 1 May 2009 13:55:57 -0700 (PDT)
> When you need to query with this much data, being able to restrict your
> search to a single or even a couple of partitions - you WILL become a
> believer in the use of partitions.
Again, from query access path perspective partitioning looks like rudimentary indexing. Because everything that partition pruning does index range scan does better. Yet, implementation of this rather unsophisticated idea of chopping one table into many is not stellar: I have seen optimizer failing to do partition pruning about as often as it failing to find an indexed access path. Received on Fri May 01 2009 - 22:55:57 CEST