Unanswered: Cartesian Joins in Oracle-Weird Behavior
We have a statement that is supposedly creating a cartesian join ONLY when the W.LOCKEDBY field in greater than 6 characters! Anyone heard of that? If the W.LOCKEDBY is less than 6 characters then the statement runs fast but if it is larger then it runs slow!
Here is the statement:
SELECT /*+FIRST_ROWS*/ A.QUEUE, I.FD_WIRID, A.WORKITEMID, I.FD_DOC_OBJECT_HANDLE, i.fd_scan_date, I.fd_document_id as DocumentID, w.lockedby From III_FUEL_DATA I, ATWORKITEMREFERENCE A, ATWORKITEM W Where I.FD_WIRID = A.WORKITEMREFERENCEID AND W.WORKITEMID = A.WORKITEMID AND A.Queue = 'Fuel Tickets' AND A.SERVERREQUEST = 0 AND W.LOCKEDBY = 'wilkpmb' Order By I.fd_scan_date