speed up query HELP!

From: Bill Thomason <billthomason_at_charter.net>
Date: Thu, 30 Jan 2003 10:03:34 -0500
Message-ID: <v3ifm87tcohod9@corp.supernews.com>

Hi All,
I have a query that has a need for speed. can anyone help? here you go

SELECT /*+ first_rows */ a.as_of_date,
to_char(avg(a.yield_to_worst_pct),999999.999), to_char(AVG(FLOOR(((a.yield_to_worst_date - SYSDATE)/365.25)*.5)*2),999.999),

to_char(avg(a.option_adj_spread_pct),9999.999) ,
to_char(avg(a.option_adj_yield_pct),9999.999),
to_char(avg(duration_to_worst_value), 9999.999),
to_char(avg(option_adj_duration_value), 9999.999)

FROM comp_rating_history c, analytics_nov_02 a, security s WHERE a.as_of_date= (select max(as_of_date) from analytics_nov_02)

AND c.security_code = a.security_code
AND c.as_of_date = a.as_of_date
AND c.comp_rating_id between 6 and 8
AND s.security_code = c.security_code

GROUP BY a.as_of_date;

Thanks,

Bill Received on Thu Jan 30 2003 - 09:03:34 CST