Using SQL navigator

Always develop your scripts in SQL navigator
Always test on data, and make sure you get the correct output
Benefit from the model, use System Architect to find good joins
Run Explain Plan whenever a change is made
If cost jumps seriously up or drops far down without a plausible cause, find out why
If cost is running high, sit down and think how to re-structure your query

Always develop your scripts in SQL navigator