Re: optimizer rewriting query

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: amit.poddar@xxxxxxxx
  • Date: Sat, 12 Mar 2005 22:00:38 -0500

you cannot see the re-written query, but only thing you can see is the
access plan. As Karen mentioned, you can access those views to see
in-memory plans.


On Sat, 12 Mar 2005 18:27:22 -0500, amit.poddar@xxxxxxxx
<amit.poddar@xxxxxxxx> wrote:
> Does that mean that
> we will have to reverse engineer the rewritten sql statement indirectly
> from access and filter predicates ?
> This would be very difficult in case of unnested subqueries and view
> merging.
> I have a vague recollection somebody mentioned a event for this
> thats why I asked this question.
> amit

Other related posts: