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.