9i: if you have some tables that joins in queries very frequent, consider cluster table.



-------------
PS:
Julian, I cannot undestand what have the future plans of Oracle regarding clustered tables with this. I do not think Oracle will take them out. But what do you want they to do with them??? Paint them in pink?
I just said it is a good idea that is functioning properly on 9i. As long as I do not use them on 8i, I do not have the required experience to recommend them for 8i.

[Edited by ovidius on 04-10-2002 at 04:15 AM]