Increase WorkflowGen's performances with Oracle database
WFG Team
Post a Comment
To dramatically increase WorkflowGen database performance you have to check your database optimizer mode.
If the optimizer_mode is set to CHOOSE (by default in Oracle 9i an 10g), you have to frequently (weekly by example) "ANALYZE" all the tables of your databases. This operation will generate statistics used by the optimizer to select the best mode (RULE instead of all_rows) to run a SQL query.
Another solution is to set the optimizer_mode to RULE.
If the optimizer_mode is set to CHOOSE (by default in Oracle 9i an 10g), you have to frequently (weekly by example) "ANALYZE" all the tables of your databases. This operation will generate statistics used by the optimizer to select the best mode (RULE instead of all_rows) to run a SQL query.
Another solution is to set the optimizer_mode to RULE.
RSS
Reader Comments