Use organizing keys and zone maps to help in filtering data and table scans. Choose the right type of data types especially on the join columns Join the tables on distribution keys - benefits co-located joins - avoids re-distribution of data