Best methode to cache data in packages? [message #39127] |
Tue, 18 June 2002 12:47 |
Graham
Messages: 9 Registered: March 2002
|
Junior Member |
|
|
Advice to tune lookups within a package please
We have a package that needs tuning and
we have identified three sections in a
procedure where it is repeating a large
number of lookups each time it loops through
a cursor. m repeated lookups times n loops.
What is the best methode to cache the m
lookups in a package such that we could
query the record / field in m
m = 8 fields in 100 records
Thx
|
|
|
|