I am using SYS(3054) to check the Rushmore Optimization Level on an inner join.
All info displayed indicates that the two tables are fully optimized.

When there is at least 1 record selected the last line displays:
'joining table a and table b using index tab x'.
When there are no records selected the last line displays:
'joining table a and table b (Cartesian product)'.

Is the SQL statement fully optimized?

TIA.