Query very slow

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