Re: [PERFORM] low cardinality column

[Rod Taylor]

On Thu, 2003-10-02 at 14:30, Rong Wu wrote:
> Hi,
> 
> I have a select like this:
> 
> SELECT MAX(transactionid) FROM cbntransaction WHERE transactiontypeid=0;

For various reasons (primarily MVCC and the ability to make custom
aggregates making it difficult)  MAX() is not optimized in this fashion.

Try:

  SELECT transactionid
    FROM ...
   WHERE ...
ORDER BY transactionid DESC
   LIMIT 1;

signature.asc
Description: This is a digitally signed message part