Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Ideas to workaround view merge being disabled (Answer)
I see that I never replied to the list for the answer, as given by The
Goddess herself. Rachel had me create a view of a view, putting the
function in the "outer" view while retaining the fields from the DECODE in
the "inner" view. The explain plan still isn't optimal, but now at least
the view can be merged correctly and the 1M row table lookups now use an
index.
Thanks, Rachel! :)
Rich
Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA
-----Original Message-----
Sent: Thursday, January 08, 2004 11:09 AM
To: Multiple recipients of list ORACLE-L
<sigh> stupid KVM hacking my mouse gets me again. Here's the *whole* message:
Hey all,
So, there I am on 8.1.7.4.0 creating some SQL suitable for a view:
SELECT
TS.username, TS.reportdate, TS.hours AS hours,
TS.productline, ST.SUBTASKID "DEFECTID", ST.DESCRIPTION "DEFECT_DESCRIPTION"
T1 TS, T2 ST, T3 TD, TEAM ,
TS.TASKID = TD.TASKID (+) AND TS.TEAMID = TEAM.TEAMID AND TS.WORKORDERNO = SC.WORKORDERNO (+)
The doc says the workaround is to move the DECODE outside the view. This won't work for us as the end-user is <sigh> MS Access. Anyone have an idea other than a RULE hint to get around this?
TIA,
Rich
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Jan 12 2004 - 12:34:35 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |