> Is it even possible to cluster a table based on the clustering scheme
> (which is
> not the link_id ...) from the master table?
>
> Can you gurus think of a better strategy? :) (Please??) :)
You can create a functional index on a function which returns the desired
order by looking in the main table, cluster it, then drop the index...