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
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 (cost=21173.70..21173.70 rows=1 width=4)
- Seq Scan on annuncio
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: