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 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228407 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
