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