RE: Star Transformation Issue

From: Deas, Scott <Scott.Deas_at_lfg.com>
Date: Thu, 22 Oct 2015 20:46:17 +0000
Message-ID: <C1FB7BA65B13C542B2CB1CE5DB8F74AF1B60F54E_at_NC2PWEX501.us.ad.lfg.com>

I have, and it’s still doing the re-write and it’s still doing the rewrite and breaking the query up into multiple query blocks.

TE: Checking validity of table expansion for query block SEL$E4256C99 (#2)
TE: Bypassed: No partitioned table in query block.
TE: Checking validity of table expansion for query block SEL$AAF2027A (#1)
TE: Bypassed: No relevant table found.
ST: Query in kkqstardrv:******* UNPARSED QUERY IS *******

…
ST: not valid since query block has less than 3 tables discarded since not big enough
try to generate transitive predicate from check constraints for query block SEL$AAF2027A (#1) …
kkqctdrvTD-start on query block SEL$AAF2027A (#1) kkqctdrvTD-start: :

    call(in-use=676648, alloc=688160), compile(in-use=2315304, alloc=2900080), execution(in-use=9160, alloc=12144)

ST: not valid since query block has less than 3 tables discarded since not big enough

Thanks,
Scott

From: Sayan Malakshinov [mailto:xt.and.r_at_gmail.com] Sent: Thursday, October 22, 2015 4:36 PM To: Deas, Scott
Cc: oracle-l_at_freelists.org
Subject: Re: Star Transformation Issue

Have you tried to rewrite the query without ANSI joins? Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 22 2015 - 22:46:17 CEST