> What sort of landmines are you referring to? For example the Oracle's incapacity of reordering tests of different kinds (as in constants, functions, rows...)

> What sort of landmines are you referring to? For example the Oracle's incapacity of reordering tests of different kinds (as in constants, functions, rows...) when optimizing a query; or the quadratic run time of triggers that change data in large updates.