Re: Partitioning Best Practices
From: <phil_herring_at_yahoo.com.au>
Date: Wed, 9 Jul 2008 17:35:36 -0700 (PDT)
Message-ID: <a5ee5b24-8395-44b1-9bb7-911c1c9efffd@59g2000hsb.googlegroups.com>
Date: Wed, 9 Jul 2008 17:35:36 -0700 (PDT)
Message-ID: <a5ee5b24-8395-44b1-9bb7-911c1c9efffd@59g2000hsb.googlegroups.com>
On Jul 10, 10:14 am, mc..._at_hotmail.com wrote:
> In other words does having an empty MAXVALUE partition have any
> bearing on performance for queries against the partitioned table...?
All the plans I've seen have partition pruned correctly - i.e., the existence of the overflow partitions haven't influenced them.
- Phil