Hi all,

I have performance problem with query. I get result right but it is very slow.
I have two tables with 500,000 rows in each. The tables are hbm_matter & tbh_matter_summ. I wrote query as follows.

Select matter_code,matter_name
From hbm_matter h, tbh_matter_summ s
Where hm.matter_uno = s.matter_uno and
s.billed_fees >0 and
_agent = '08588A'

It returns 134 rows with correct information. It takes about 2 min on server. On client it takes more time than server. Actually when query runs, because of join it merges two tables & then scan for creteria. How I can make this qurey run faster? using subquery? Can anybody help me with this? Thanks in advance.