Optimization Techniques in Oracle Application Development

There are Different Different Optimization Techniques.

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

====> If You like the Article Feel Free Comment.