chain_cnt

Just kidding.

Well I am still waiting if somebody could please help me.

Thanks.

Please let me know soon.

I request somebody to help me please.

Thanks.

Given the complexity of the query, view definition and the number of rows, 65 seconds does not seem to be too bad. However, if you want to improve the performance, you need to do some homework.

1. Run the query directly against the tables. Since you are using inline view for your view definition, you just have to add the where clauses there. Run explain plan to see whether there is improvement.

2. You have to play around with the join order. Use the most restrictive join condition first. This is true for both query and the view definition. Again, run explain plan to measure the performance.

3. Tune your indexes. Obviously you need indexes on columns(t1. trans_no, s1.acct_id etc). Again, you can play around and see whether an index actually improves query response or makes it worse.