Example of using sql profile to use switch to a different execution plan

Below are the 2 SQL statements, the first one uses the index AAA_IDX and then second one does a full table scan and in this case we want to make the first one that uses the index use the same execution plan as the 2nd one. SQL statement: select * from aaa e where ename = 'aaa'; select /*+ FULL(e) */ * from aaa e … Continue reading Example of using sql profile to use switch to a different execution plan