Tips:
1.use EXISTS instead of IN as it uses indexes
2.remember DECODE will ignore indexes
3. Use Hints
Tips
Friday, January 30, 2009
Performance Tuning
Tips:
1.use EXISTS instead of IN as it uses indexes
2.remember DECODE will ignore indexes
Subscribe to:
Posts (Atom)