Home » RDBMS Server » Server Administration » Re: Why so slow?
Re: Why so slow? [message #370680] Wed, 19 January 2000 00:01
Nanduri V Rao
Messages: 13
Registered: January 2000
Junior Member
1. The first three lines could be made into a single query. Something like
select to_char((sysdate - 45 + i),'mm') into v_monthrepdt , to_char((sysdate - 45 + i),'yyyy') into v_yearrepdt from dual;

2. You need to check the cardinality of each of the 'and' conditions and place them accordingly.

3. Also you may consider to alter this query to a view.
Previous Topic: Which method is faster!!!!!
Next Topic: inserting into nested tables
Goto Forum:

Current Time: Sun Apr 11 04:46:49 CDT 2021