by fetching say 1000
to 5000 rows at a time?
Best Regards
Sriram Kumar
From: Tracy Rahmlow
[mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004
10:54 PMTo: Multiple recipients of list ORACLE-LSubject:
Sql Tuning Thoughts?
This statement is from a batch program within a
pl/sql procedure
PROTECTED] On Behalf Of Tracy
Rahmlow
Sent: Thursday, January 22, 2004
11:24 AM
To: Multiple recipients of list
ORACLE-L
Subject: Sql Tuning Thoughts?
This
statement is from a batch program within a pl/sql procedure. (Also, I have many
similar ones within the process) The policy table has
This statement is from a batch program within a pl/sql procedure. (Also, I have many similar ones within the process) The policy table has approximately 6.2 million rows. The procedure is to incrementally(daily) build an extract table from multiple tables. The extract table is then used for
are strictly personal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Tracy Rahmlow
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 22, 2004
12:24 PMTo: Multiple recipients of list ORACLE-LSubject:
Sql Tuning Thoughts?This statement
Comments in line.
On 01/22/2004 12:24:26 PM, Tracy Rahmlow wrote:
This statement is from a batch program within a pl/sql procedure.
(Also, I
have many similar ones within the process) The policy table has
approximately 6.2 million rows. The procedure is to
incrementally(daily)
build an extract
Since you're doing an aggregate function, you may want to investigate
using materialized views here. Since, I'm assuming, policy
effective dates aren't something that changes on a minute-to-minute
basis, you could set up a materialized view that refreshed every night
and would answer this