i want to use Hash index to Eliminate Redistribution only not to fetch the column Data.
i'm using the following DDL:
I am of the opinion that you use STJI instead of HJI. It is good that you collect stats too. You join with other tables, so you know the joining in mind. You can run explain and see how it behaves.