Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jesus4u
Posting Yak Master
204 Posts |
 Posted - 2007-09-05 : 09:07:17
|
| 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 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-05 : 09:19:55
|
| Might be worth asking on dbformus as there are not many here that know much about Oracle.Kristen |
 |
|
|
jesus4u
Posting Yak Master
204 Posts |
Posted - 2007-09-05 : 09:25:22
|
| thanks |
|
|
|
|
|
|
Cartesian Joins in Oracle