Re: Create Multi record
From: AK <ak_tiredofspam_at_yahoo.com>
Date: 26 Mar 2004 19:36:49 -0800
Message-ID: <46e627da.0403261936.267c69ff_at_posting.google.com>
Date: 26 Mar 2004 19:36:49 -0800
Message-ID: <46e627da.0403261936.267c69ff_at_posting.google.com>
>
> For performance issue in Oracle (Please refer <Oracle performance and
> tunning>), avoid using JOIN if possible, and avoid using CASE if possible,
> especially avoid using them together. It costs much data buffer cache and
> CPU resource. More SQLs cost also more space in shared pool and SQLs (in
> shared pool, it is called curser) parse time.
did a little bit of benchmarking, the performance wasn't bad, not at all. there are no hard and fast rules in queries optimization Received on Sat Mar 27 2004 - 04:36:49 CET