lieni

• Jul 30th, 2007

 

there are many tips!

1) inside a cursor never  perform an other sql or call a function performing an sql, join that table better to the cursor body.

2) perform bulk operations

3) avoid in (subselect) better join this table to the master select

4) avoid or

5) avoid like with leading %

6) avoid substr

7) in general avoid function in the where clause

8) avoid logging

9) avoid writing unneeded code

10) avoid any code (hahaha)

show me the procedure and i could explain in detail