[GENERAL] Cluster all tables in database to PK index

Besides writing a script that looks through the DDL of all tables, and CLUSTERs all tables with PK constraints, is there a quicker way? Thanks. -- Regards, Hannes Dorbath ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] Cluster all tables in database to PK index

Besides writing a script that looks through the DDL of all tables, and CLUSTERs all tables with PK constraints, is there a quicker way? Is this really a sensible thing to do? As often as not, you want to cluster on foreign keys... -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/