Hi, i have a problematic query which originally doesnot finish at all. then i created query specific projection for "dwh" schema, after which this query takes 83 mins. i need to further tune this query and need some advises and recommendations. i am attaching the following :- 1) query 2) explain pla...