Re: [PERFORM] finding a max value
Re: [PERFORM] finding a max value
От:
Rosser Schwarz <rosser.schwarz@gmail.com>
Дата:
On Fri, 02 Jul 2004 20:50:26 +0200, Edoardo Ceccarelli wrote: > This is the query: > select max(KA) from annuncio > wasn't supposed to do an index scan? it takes about 1sec to get the result. > TIP 5: Have you checked our extensive FAQ? I believe this is a FAQ. See: http://www.postgresql.org/docs/faqs/FAQ.html#4.8 Try "select KA from annuncio order by KA desc limit 1;" /rls -- :wq