We have a query which is running slower than expected or if I may say slower than accepted. When I look at the explain plan, its the hashjoin that is taking 50-70% of the time. When I click on it, I see kernTime taking the most.
Is there anything that I can do OR is it that kernTime means that the server CPU is taking time?
There are 4 datasets in a bucket that are being joined. 2 datasets have 4k & 5k records, the other 2 have about 100 records. Fetch & IndexScan is not taking time. Is there a way that I can reduce the time taken by hashjoin?