| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.oracle -> Re: Create Multi record
>
> 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 Fri Mar 26 2004 - 21:36:49 CST
 |
 |