Re: Indexing View Columns?

From: joel garry <joel-garry_at_home.com>
Date: Tue, 15 Mar 2011 14:25:51 -0700 (PDT)
Message-ID: <c0fce781-06f6-4ea2-92d2-a8be410b30ed_at_18g2000prd.googlegroups.com>

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

jg

--
_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