Oracle Tuning: Step 4 - Restructure
* Avoid the use of transformations in the WHERE clause
* Avoid using functions in WHERE clause
* Avoid expressions different data type conversions
* Avoid implicit data
* Write separate queries for specific tasks.
* Using UNION ALL
* Use EXISTS instead of IN for Subqueries
* Control access forms and order of the joins with hints
* Write the WHERE predicates using AND e = do not use LIKE as possible
0 comments:
Post a Comment