Re: [BUGS] SELECT min(id) FROM test; uses seqscan

[Peter Eisentraut]

> SELECT min(id) FROM test; uses sequential scan even if an index on "id" exists. 
>VACUUM ANALYZE doesn't help.

This is not a bug.  In the current implementation, min and max cannot make
use of an index directly.

-- 
Peter Eisentraut   [EMAIL PROTECTED]   http://funkturm.homeip.net/~peter


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]