Hi Team,
I have 3 tables one with 84k records , one with 20 records and another one
with 1000 records and am fetching few columns from all these tables with
some conditions . It’s taking forever and in explain plan it is having
nested loop and cost is high. I have created index also for these tables
but still it’s taking sequential scan.
Any suggestions
Thanks & regards
Firthouse