Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the different Optimisation techniques ?

April 26, 2017different optimisation techniques

0

Posted

What are the different Optimisation techniques ?

1 Answer

0

Posted

A10) 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 assign a single cursor for all SQL statements. This slow downs the processing because for everytime the SQL must be parsed whenever they are executed. f45run module = my_firstform useid = scott/tiger optimize_Tp = No more questions are here : http://knoworacle.wordpress.com/2008/06/08/oracle-technical-faq-part-2/ Part 3 is here : http://knoworacle.wordpress.com/2008/06/09/oracle-technical-faq-part-3/ Part 1 is here : http://knoworacle.wordpress.