Re: TUNING

In article <74r6eb$pv4$1_at_pegasus.csx.cam.ac.uk>, "E. Nunns" <en201_at_cus.cam.ac.uk> writes
>
>We have the following situation:-
>
>Forms 4.5 block based on a view.
>
>This view is based on a view of a view of a view of some base tables.
>We also have functions embedded within these views. All of this is
>running on an oracle 7.3 db under VMS using the cost based optimiser.
>
>Performance is poor. Does anyone else have similar problems or can make
>any broad suggestions regarding where to start tuning?
>
>Elaine

Views in general are slowwww. PL/SQL on the other hand is fast, could you not achieve similar results by shifting some of your application to PL/SQL? We've found this to be a major improvement.

Look to tune your SQL before your database. I.E. avoid the likes of NOT IN checks etc.

-- 
           |    Andrew Hodgson - Andrew_at_tcamiga.demon.co.uk   |
           |                     www.tcamiga.demon.co.uk      |
           |  Amiga 1200 030 33Mhz    |       6x86 P150+      |
           | 250Mb HD   HD Disk Drive | Quad Spd CD 5.3 Gb HD |
           | 6Mb Ram | CDTV | Motorola SurfR 56K |  80Mb Ram  |
                           Resistance is futile...