Oracle DB optimizer configuration

On a project, I had a SQL query which was already tuned and working file. However, Oracle optimizer was chosing the full tale scan in place of indexes on the production system. After setting the following system properties, the behavior of the optimizer is changed as we wanted: optimizer_index_cost_adj=10 optimizer_index_caching=90 If you experience that Oracle … More Oracle DB optimizer configuration