RE: Star Transformation Issue

  • From: "Deas, Scott" <Scott.Deas@xxxxxxx>
  • To: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • Date: Thu, 22 Oct 2015 20:46:17 +0000

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@xxxxxxxxx]
Sent: Thursday, October 22, 2015 4:36 PM
To: Deas, Scott
Cc: oracle-l@xxxxxxxxxxxxx
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.**

Other related posts: