|
|
|
|
|
|
Re: High optimizer cost ..Please help me out to tune the query. (merged 4) [message #384161 is a reply to message #383305] |
Mon, 02 February 2009 07:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
So you've got a query that is union of three queries against a view.
You haven't given us a definition of that view.
You haven't given us definitions of the underlying tables.
You haven't even given us a readable explain plan.
If you want anything approaching usefull help you're going to have to provide us with all of the above.
That said, you're going to struggle to make a query that unions a view 3 times then groups the result and sorts it run fast.
|
|
|