SQL Optimization

Use this hints to write efficient SQL's in AE

using Optimizer Hints :

http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/hintsref.htm#4894

SQL Tuning:

http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/sql_1016.htm#35171

Source:
Oracle