Shelby Cain <[EMAIL PROTECTED]> writes:
> Consider the following queries:
> #1) explain analyze select txn_code, count(*) from
> inventory_txns where txn_date > '07-FEB-2004' and
> txn_date <= current_date group by txn_code;
> #2) explain analyze select txn_code, count(*) from
> inventory_txns wh
Standard cygwin Postgresql 7.4.1 package on Windows
2000 box.
I have a relatively small table (about 1 million
records) that contains inventory transaction data with
an index on transaction date (date datatype). Since
the data was inserted chronologically, the transaction
date column is strongly
