Home » SQL & PL/SQL » SQL & PL/SQL » Faster query with less data?
Faster query with less data? [message #1932] Tue, 11 June 2002 22:44 Go to next message
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 Go to previous message
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.
Previous Topic: Abt Stored Procedure in Forms 6i
Next Topic: Trapping PL/Sql Error Messages
Goto Forum:
  


Current Time: Fri Mar 29 02:05:28 CDT 2024