(Lockwood Lyon) Another aspect of efficient clustering is that tables are commonly joined by their primary and foreign key columns. In an order entry system containing a customer table and an order table, each might be clustered by their primary key (customer number and order number, respectively).
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help