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
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
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
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