Cases should be avoided -1. DO NOT use FUNCTIONS (,TO_NUMBER ,Decode,NVL, TO_CHAR) unnecessarily when a simple join would work 2. DO NOT use ‘SELECT *’ explicitly. Make sure that you select only required columns from the tables. 3. DO NOT use HAVING clause where a WHERE clause would do. 4. DO NOT use ORDER BY [...]