Subquery Refactoring Oracle 8.1.7

[Custom24]

Is this possible?

For example, if I pass SQL
(A union B) minus (A intersection C),
is there any way to make Oracle understand that it needs to keep the results of subquery A in memory and use it again?

The explain plan shows that Oracle does not do this.

And this document seems to suggest that Oracle 9 can do this; see section 4.3

http://www.oriole.com/papers/Its_the_algorithm.pdf

Thanks for any help


Mark