What rule optimizations are possible in SQL query

For optimization of a sql query, u first need to check the bottleneck and then taste the query with CBO/RBO. Using the option which is best for ur environment. For CBO to work , u need to analyze the table first then only it will have some effect on the performance of the query.