We have a vendor application and while cost based works fine for tens of thousands of queries there is one which does not. It joins between two tables and uses a select max. When the inner table has thousands of rows it no longer uses the index and runs for a very long time impacting performance. It runs fine using the rule based optimizer.
While the vendor will fix this, in the mean time is it possible to force a single specific SQL ID to use a rule base optimizer? This would need to be from the database sides as we cannot modify the query itself.