Re: [GENERAL] Directing Partitioned Table Searches

2011-02-07 Thread Vick Khera
On Mon, Feb 7, 2011 at 1:17 PM, Bill Thoen wrote: > Thanks. That sounds simple enough. Since I want to automate this, I guess > the next step is to learn how to create and  execute a "dynamic" query.  I > think I know how to do that. > In perl, it looks something like this: $part = compute_parti

Re: [GENERAL] Directing Partitioned Table Searches

2011-02-07 Thread Bill Thoen
Vick Khera wrote: Your best bet is to know which partition you need and write your query that way dynamically, rather than trying to use a generic query and have the DB do the constraint exclusion. In your above case, if you know that 'zone' will limit you to just the MI table, then specify the

Re: [GENERAL] Directing Partitioned Table Searches

2011-02-07 Thread Vick Khera
On Fri, Feb 4, 2011 at 7:35 PM, Bill Thoen wrote: > And this selection will result in ALL partitions being searched. But why? > SELECT cluid, farmid > FROM clu JOIN farms ON ogc_fid=link > WHERE state=zone The constraint exclusion code does not execute your constraints to decide whether to look a

[GENERAL] Directing Partitioned Table Searches

2011-02-04 Thread Bill Thoen
In a partitioned table, is it possible to specify the partition for a query to search using a variable instead of a constant? EXAMPLE: Join another table to the partitioned one Table: clu (partitioned by state) ogc_fid bigint cluid char(16) state bpchar(2) constraint: state='mi' (or 'co', 'k