definately, collecting stats is very effective.... You can also try using GTT tables. If a query is long and have lots of joins and derived tables.. GTT is the best option. Because you cannot use...