Hi,
I have following query:
----------------------------------------------------
select
a.project_id,
a.description Projektname,
a.PROJECT_NUMBER Projektnummer,
b.TRANSLATE_TEXT Projectstatus,
f.TRANSLATE_TEXT Projektart,
e.Description Auftraggeber,
g.last_name|| ', ' ||g.first_name Projektleiter,
i.name
FROM
TB_PRJ_PROPERTIES a,
TB_BASE_LNG_TEXT b,
TB_PRJ_DESCRIPTION_STATE c,
TB_STD_PROJECT_TYPE d,
TB_PRJ_CUSTOMER e,
TB_BASE_LNG_TEXT f,
TB_HM_STAFF g,
TB_PRJ_MEMBER h,
TB_STD_DEPARTMENT i
WHERE
a.STATE_ID=c.STATE_ID AND
c.TEXT_ID=b.TEXT_ID AND
b.lng_id=1 AND
a.PROJECT_TYPE_ID=d.PROJECT_TYPE_ID AND
d.TEXT_ID=f.TEXT_ID AND f.lng_id=1 AND
a.CUSTOMER_ID=e.CUSTOMER_ID AND
a.project_id=h.project_id (+) AND
h.staff_id=g.staff_id AND
h.IS_PROJECT_MANAGER=1 AND
a.IS_DELETED='0' AND
a.DEPARTMENT_ID=i.DEPARTMENT_ID
ORDER BY
a.description
----------------------------------------------------
that query fills up my data devspace with temp and ends with:
SAP DBTech SQL: [-904] Space for result tables exhausted
I increased the data by a large value, but that query fills allways the
data. (backup file size 2MB, data devspace 500MB)
If I remove the outer join, the query works fine and fast.
explain tells me a cost with outer join >2E10
without outer join 485
oracle runs both query very fast.
what can I do?? (i don't want to break this in a union)
thanks
(Kernel 7.3.0 023-000-085-389 on linux 2.4.18 dual pII)
--
Thomas Markus
Tel: 030 29 36 399 - 18
mailto:[EMAIL PROTECTED]
Proventis GmbH
Torellstr. 1
10243 Berlin
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
