Oracle APEX performance tuning

on


Performance tuning of interactive grid  

 Version : 20.2

You might know that a certain index is more selective for certain queries. Based on this information, you might be able to choose a more efficient execution plan than the Optimizer. In such a case, use hints to force the Optimizer to use the optimal execution plan.

Examples

When accessing the table employee try to use the index emp_department_ix
INDEX (employees emp_department_ix)
Enable the use of the WITH plsql_declarations clause within the SQL query
WITH_PLSQL

Additional Information

  • Type: Text



Sample given below for an Parallel execution :






Comments

Post a Comment