The Various Optimisation techniques are
a) Execute Plan :: we can see the plan of the query and change it
accordingly based on the indexes
b) Optimizer_hint ::
set_item_property('DeptBlock',OPTIMIZER_HINT,'FIRST_ROWS');
Select /*+ First_Rows */ Deptno,Dname,Loc,Rowid from dept
where (Deptno > 25)
c) Optimize_Sql ::
By setting the Optimize_Sql = No, Oracle Forms assigns a single cursor
for all SQL statements.This slow downs the processing because for
evertime the SQL must be parsed whenver they are executed.
f45run module = my_firstform userid = scott/tiger optimize_sql = No
d) Optimize_Tp ::
By setting the Optimize_Tp= No, Oracle Forms assigns seperate cursor
only for each query SELECT statement. All other SQL statements reuse
the cursor.
f45run module = my_firstform userid = scott/tiger optimize_Tp = No