Following Stephane's advice, I rewrote the query to use underlying tables rather than the view.
The execution plan looks much better and the elapsed time came down appreciably.
My Question is , Since I was simply selecting from the view, eliminating a lot of columns and adding a few more predi
>- --- Original Message --- -
>From: New DBA <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Thu, 18 Sep 2003 05:59:37
>
>Hi All,
>
>I'm new on this list and need help on tuning the
>following query. I hope the gurus on this list will
>help