Re: Indexing View Columns?
Date: Tue, 15 Mar 2011 14:25:51 -0700 (PDT)
On Mar 10, 12:15 pm, NewUser2008 <mcse..._at_gmail.com> wrote:
> Don't get me wrong: The solution with the view from first post works
> technically. It's just damn slow with a growing number of UNION ALL
> statements. But perhaps it's really not solvable on dbms level.
Well, you can upgrade. http://blogs.oracle.com/optimizer/2011/02/optimizer_transformations_join_factorization.html
-- _at_home.com is bogus. http://www.computerworlduk.com/news/applications/3265253/oracle-to-compete-against-microsoft-with-mysql/Received on Tue Mar 15 2011 - 16:25:51 CDT