Re: Strange problem.

>Have you got an article number or URL?

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:7931218716504 and search for the word "rug."

As someone else suggested, you want to store outlines, Plan Stability http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4144341695521

>One would think that if the parameter keeps the
>optimizer from using a hint a run time, it would do the same when you
>run explain plan.

If it starts with an underscore, all bets are off.

jg

--
@home.com is bogus.
Marketplace of ideas, riiiiiight.
http://www.signonsandiego.com/uniontrib/20051206/news_1b6wiki.html