Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
3
Impact
~361 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Oct
2
comment How to modify an update in Oracle so it performs faster?
@a_horse_with_no_name Thanks, I already tried that and it continued performing a full table scan. Weirdly, the explain and cost didn't change. Also, universe and fund id can be repeated, because one fund can have several fees of the same type.
Oct
2
comment How to modify an update in Oracle so it performs faster?
@beherenow You're totally right, I misplaced the minus. It is FEE_SCHEDULE + ETL_FEE_SCH_TMP = FEE_SCHEDULE_HISTORICAL.