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...

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

Reply via email to