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.

Report message to a moderator

Previous Topic: Which method is faster!!!!!
Next Topic: inserting into nested tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 25 10:04:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.