Re: Performance issue

From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1998/01/13
Message-ID: <69enn4$99j$1@marri.bs.wa.gov.au>#1/1

Thanks - but the view is used in many places and was created to greatly simplify applications.
It was after very careful consideration that we decided to use a view (unfortunately not careful enough!). The reports which use this view together with many other tables, database functions, outer joins etc are highly complex and replacing references to the view with selects from both tables becomes a nightmare.
Basically we want to join archive data with live data without overburdening a suite of already overly complex statistical reports. If we can't find a way of 'fooling' Oracle we will probably have to take a 'work table' approach.

Allen Kirby wrote in message <34BA35B1.1877_at_att.com>...
>Peter McKenzie wrote:
Received on Tue Jan 13 1998 - 00:00:00 CST