TB1 200K rows,
TB2 9M rows,
TB1 join TB2 based on certain conditions, all condition columns has been
indexed individually, even function based index has been build.
due to the fact PL/SQL's low efficiency, all functions has been converted to
JAVA functions and embeded into the database. Indexes were build on top
these functions.
Cartesian factor from TB1 to TB2 is about 4, and expected resultset of 1M
rows.
Oracle cannot correct choose the most efficient query plan by using indexes
, full table