Edoardo Ceccarelli <[EMAIL PROTECTED]> writes:
> This is the query:
> select max(KA) from annuncio
>
> field KA is indexed and is int4,
>
> explaining gives:
> explain select max(KA) from annuncio;
> QUERY PLAN
> ---
> Aggregate (
On Fri, 02 Jul 2004 20:50:26 +0200, Edoardo Ceccarelli <[EMAIL PROTECTED]> 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://