OPTIMIZER_MODE « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. OPTIMIZER_MODE
29.23.OPTIMIZER_MODE
29.23.1.alter session set OPTIMIZER_MODE = choose
29.23.2.alter session set optimizer_index_cost_adj, alter session set optimizer_index_caching
29.23.3.alter session set optimizer_max_permutations=80000
29.23.4.alter session set optimizer_mode=all_rows
29.23.5.alter session set optimizer_mode=first_rows