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.


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

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

Reply via email to