Re: Star Transformation Issue

From: Tim Gorman <tim_at_evdbt.com>
Date: Thu, 22 Oct 2015 15:10:31 -0600
Message-ID: <562950C7.1050805_at_evdbt.com>



+1 with Sayan's suggestion.

I'd like to first point out that the query is combining the WHERE clause filtering predicates within the ON clause join predicates, but I don't know if that would impact star transformation or not.

It would be more effective to first attempt rewriting the query in old-style Oracle syntax and see if that works, because it definitely should. If star transformation still doesn't happen, then there is almost certainly a missing prerequisite (i.e. parameter setting, bitmap indexes on dimensional-key columns, etc). If however it does work with the old-style Oracle syntax, then I would consider seeing if it then might work when the ANSI SQL syntax is specified correctly (i.e. join predicates in ON clauses, filtering predicates in WHERE clauses).

On 10/22/15 14:35, Sayan Malakshinov wrote:
> Have you tried to rewrite the query without ANSI joins?

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 22 2015 - 23:10:31 CEST

Original text of this message