Re: Slow performance on MAX(primary_key)

Hi Keith:

--- Keith Gray <keith@heart.com.au> wrote:
> Help,
> 
> I have just been comparing some large table
> performance
> under 7.1 using the
> 
>     select max(primary key)from table;
> 
> We are using this for various functions including
> sequence.
> 
 Try using the following as alternative :  SELECT primary_key FROM table ORDER BY primary_key desc LIMIT 1;
 This should work if primary_key is indexes.
 As of now, Max() doesn't utilizes the indices hence
it always do a sequential scan.
 Hope that helps,

regards,
ludwig.







__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com