Yes, that is how I got the original query down to 2 hours. When I started it ran 3 times as long and indexes were what helped the best.
I will look at the materialized view. It will probably help. Hitting 5 or 6 flat tables or equivilents will be faster than all of the subqueries, etc. >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: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:228409 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5