Originally posted by raghud
This sql will not go into cartesian product. Some improvement can be done by taking the filters to the bottom and by creating function based indexes such as upper() and index on test_date,clienttype ...

Any way good luck on outer joins
I never said it was a catesian product. With so many tables being joined and no information about the key structure. It could be that he doesn't have a cartesian product, and that a few simple tweaks will make all the difference. But without an explain plan, and with the query having so many outer joins, how can you say what it will do?