Wednesday, April 23, 2008

Building A Tolerance To Cats

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