Re: UPdates
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 12 Mar 2002 02:18:01 GMT
Message-ID: <tzdj8.20126$702.11579_at_sccrnsc02>
Date: Tue, 12 Mar 2002 02:18:01 GMT
Message-ID: <tzdj8.20126$702.11579_at_sccrnsc02>
An example of what you are trying to do would help. If you have indexes on
fields that are being updated then that will slow things down because the
index has to be updated. If you are doing calculations eg to_char or
to_date then that will slow things down over a constant. (eg
to_date(some_constant,'format') vs a date.)
Jim
"oraclehyd" <oraclehyd_at_yahoo.com> wrote in message
news:fc615b88.0203110739.52a1bead_at_posting.google.com...
> What are the different factors for improving performance on updates
> and procudures that contains lots of calculations (eg many decodes).
Received on Tue Mar 12 2002 - 03:18:01 CET