In Rdb (for instance) you can edit the plan if you want. (Oracle too,
IIRC -- but I never have edited a plan in Oracle)
Sure, it opens a big can of worms, but it would be nice for someone
technically inclined to be able to fix a plan if they know better than
the SQL compiler did.