There are some tools to force specific hints/plans on the engine depending on the database e.g. SQL Plan Management in Oracle