Hi, I have a long running querry which returns 59k rows in 25 minutes. The querry is doing a select on a view and in the view I am joining 3 tables. I am using the RULE based optimizer and I tried analysing tables and using the CBO. It still takes 25 minutes. I tried using various hints without much luck. The TKPROF shows that no FULL table scans is being done. Please see attached TKPROF.
Couls someone please guide me in the right direction. Thanks.
