Why would you then drop the index? Performance and storage issues? I imagine that I would cluster the table at regular intervals to maintain the ordering, so I'd need to to keep the index around, yes?
--- PFC <[EMAIL PROTECTED]> wrote: > > > > 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 > ____________________________________________________ Sell on Yahoo! Auctions no fees. Bid on great items. http://auctions.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings