1. Do not use functions in where cluase, it will not use the indexe unless you have FBI.

2. Make use of hints to improve performance.

3..

Three are more "sql good practices" to follow do not remember right now..

Sanjay