On Wed, Apr 11, 2001 at 11:03:53AM +0200, Konstantinos Agouros wrote:
> > what does explain command show about your query?
> NOTICE: QUERY PLAN:
>
> Subquery Scan *SELECT* (cost=0.02..0.03 rows=1 width=40)
> -> Aggregate (cost=0.02..0.03 rows=1 width=40)
> -> Group (cost=0.02..0.03 rows=1 width=40)
> -> Sort (cost=0.02..0.02 rows=1 width=40)
> -> Nested Loop (cost=0.00..0.01 rows=1 width=40)
> -> Seq Scan on websensebycat a (cost=0.00..0.00 rows=1 width=24)
> -> Seq Scan on netscapereduce b (cost=0.00..0.00 rows=1 width=16)
> SubPlan
> -> Seq Scan on urlcounts (cost=0.00..0.00 rows=1 width=12)
Umm, standard question: Have you run VACUUM ANALYZE?
Chris
--
chris@mt.sri.com -----------------------------------------------------
Chris Jones SRI International, Inc.
www.sri.com