Does the oracle always does the cartesian product before filtering out the records based on join condition
select * from category_new, category_temp where
category_new.category = category_temp.category
what will happen in this case will the oracle behind the scene fetch all the records from both the tables, then perform cartesian product and then apply equi join.
Is this the case that oracle will perform cartesian product each time we ask for join ?