Re: Partition Elimination Failing to Work

From: dias <ydias_at_hotmail.com>
Date: 22 Feb 2003 01:08:52 -0800
Message-ID: <55a68b47.0302220108.49356cd8@posting.google.com>

Hi,
you can also use $ORACLE_HOME/rdbms/admin/utlxpls.sql (or utlxplp if parallel query).

Dias

george_at_41donny.freeserve.co.uk (Gee) wrote in message news:<f7859e6f.0302211241.1cc92a60_at_posting.google.com>...
> Roelof,
> Thanks for the advice.
> The explain plan worked and indeed partition elimination is being
> used! I was using the latest "TOAD" to determine the explain plan, and
> it does not provide the partition start/end information, although the
> headings seem to indicate that it should. Anyway, problem fixed.
>
> Regards,
>
> Gee
Received on Sat Feb 22 2003 - 03:08:52 CST