Friday, January 30, 2009

Performance Tuning

Tips:

1.use EXISTS instead of IN as it uses indexes

2.remember DECODE will ignore indexes

No comments: