On 12:54 pm 07/31/08 "Mike Gould" <[EMAIL PROTECTED]> wrote:
> 1. Is the planner/optimizer intelligent enough to know when we are
> not doing a query based on location?
In short yes.
If the DB doesn't see the condition by which your tables are partitioned it
will search all the partitions.
> 2.
I have several tables that we have partitioned by physical location. This
seems to give us the best overall performance when doing location specific
queries. I have a few questions.
1. Is the planner/optimizer intelligent enough to know when we are not doing a
query based on location? For ex
