1. Is index always the best way.. Should I really use the index or just do a full table scan.
2. Use bind variables everywhere. Parse once execute many times.
3. Should i partition the table ? What type of partition ? (range,list, hash etc)
4. What can be done in SQL is better done in SQL, never [...]
Filed under: oracle | Tagged: guidelines, tips | Leave a Comment »
