I've recently had an 'issue' with the follwoing:
~320m row table, UPI A, B, C where A, B and C are all INTEGER. Each of these cols has a "FORMAT '9(n)'" clause (where 'n' differs). I am selecting from this table, joined to a table (8 rows, UPI 'B') on index 'B' which is defined...