Look into materialized views. Basically, they're like views, but instead of doing a query every time to populate the data, it's snapshot data. You can schedule a refresh of the views, so that the data stays"in sync" as much as is reasonable. But, it should theoretically speed up your queries.
Have you tried doing any optimization hints for your query? Or your views for that matter? Or adding indexes to the underlying views? On 2/20/07, Russel Madere <[EMAIL PROTECTED]> wrote: > I'm actually trying to replace a number of views. The views are slowing down > a massive query. This query takes nearly 12 hours to execute right now. > Before I added a view (to find the network district instead of the regular > district) the query ran in about 2 hours. This is reasonable because of the > number of records that must be parsed (over 1 billion) in all of the base > tables. > > >I've not really had much need to use temp tables. So, I don't know a > >lot about them. But, they're either session or transaction specific > >(depending on how you create them). > > > >Are you doing something in PL/SQL? Cause there's also pl/sql tables > >that you could look into. > > > >There's also materialized and regular views that might do what you're > >looking for, depending on what you're trying to accomplish. (You never > >did answer that "what are you trying to accomplish?" question.) > > > >-d > > > > > >On 2/20/07, Russel Madere <[EMAIL PROTECTED]> wrote: > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228408 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
