Originally posted by ovidius
9i: if you have some tables that joins in queries very frequent, consider cluster table.
Oracle keeps cluster tables only for backward compatability and Oracle will not make any improvements on cluster tables in future releases.