Skip site navigation (1) Skip section navigation (2)

Query very slow

From: "Luz Lopez" <viaris(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Query very slow
Date: 2001-11-10 18:52:49
Message-ID: F1544CxpAOAkK5LqN330000803c@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi all

Hi all

I have a query that the excution es very slow, my query is:

"select count(B.fil) as juntas, sum(C.column1),sum(C.column2), 
sum(C.column3),sum(C.column4), sum(C.column5,sum(C.column6)from table1 B, 
table2 C where C.tipo=1 and B.codigo=15 and C.fil=B.fil"

The main table have 37824 rows nad I have index for the two tables.

How can I  to improve better execution time at this query?

Regards

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


Responses

pgsql-novice by date

Next:From: Zetta DelaneyDate: 2001-11-10 19:40:32
Subject: question for you
Previous:From: BrianDate: 2001-11-10 18:26:58
Subject: SQL Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group