Faster query with less data? [message #1932] |
Tue, 11 June 2002 22:44 |
Deborah
Messages: 18 Registered: June 2002
|
Junior Member |
|
|
I have a parts transaction table with about 2 Million
rows. There is an update of this table every week.
But at any given week, the number of rows that actually
come into play out of the 2M is about 3000 records max.
The updation takes a long time. More than 10 hours.
There are some complex logic involved in between
though. But the indexes are proper and in place.
If I try the same program by deleting the 'old'
records (of course i will put them into some
archive elsewhere instead of deleting completely),
will it enhance my output?
Matter urgent.
TIA,
Debby
|
|
|
Re: Faster query with less data? [message #1935 is a reply to message #1932] |
Wed, 12 June 2002 02:20 |
alapps
Messages: 11 Registered: June 2002
|
Junior Member |
|
|
If I try the same program by deleting the 'old'
records (of course i will put them into some
archive elsewhere instead of deleting completely),
will it enhance my output?
Not necessarily. Depending upon your parameters the deleted rows may not be reclaimed. This sound like some old fashion tuning is necessary (Turn on trace for the session and verify access paths).
P.S. Be on the lookout for row migration (Is there enough free space left PCTFREE for the update to occur in the same block) Row migration will degrade the performance of the table.
|
|
|