Re: Export - can I use a hint or set a session level value?

Some possibilities come to mind.

*) your data has changed significantly, and statistics are stale

*) your data has not changed, but statistics were run incorrectly and confused the optimizer

*) your data has changed, statistics are current, but the data is now skewed and the index

   is no longer optimal

From your WHERE clause it appears that this export is a month-end process. Could it be that a significant amount of data was added during April?

Just some things to consider.

Jared

On 5/26/06, JayMiller_at_tdwaterhouse.com <JayMiller_at_tdwaterhouse.com> wrote:
>
> I'm considering this. The main problem here is our Change Management
> system. Any DDL needs to be approved and go through a change meeting.
>
>
>
> Thanks,
>
> Jay Miller
>
> Sr. Oracle DBA
>
> x68355
>
>
>
> -----Original Message-----
> *From:* GovindanK [mailto:gkatteri_at_fastmail.fm]
> *Sent:* Friday, May 26, 2006 4:34 PM
> *To:* Miller, Jay; oracle-l_at_freelists.org
> *Subject:* RE: Export - can I use a hint or set a session level value?
>
>
>
> Why not you create another table based on the rows meeting this criteria
> and export the same.
>
> ------------------------------
>
>
> *
> This message is confidential and sent by TD Waterhouse solely for
> use by the intended recipient. If you are not the intended
> recipient, you are hereby notified that any use, distribution or
> copying of this communication is strictly prohibited. This should
> not be deemed as an offer or solicitation, to buy or sell any
> product. Any 3rd party information contained herein was prepared by
> sources deemed reliable, but is not guaranteed. TD Waterhouse does
> not accept electronic instructions that would require an original
> signature. Information received by or sent from TD Waterhouse is
> stored, subject to review, and may be produced to regulatory
> authorities or others with a legal right to such.
> *
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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