Hi,
I had problems with running complicated queries before, so I split the
complicated queries into views...
This has worked fine for many months, but apparently stopped working today
for some unknown reason. It looks like the database has plenty of free
space, and the data still looks normal.
The query we are using looks like:
select * from cui_stage2, aa_table
where TE_key=AA_key(+)
(cui_Stage2 is a view).
select count(te_key) from te_table = 3132
select count(te_key) from cui_stage2 =1789
select count(aa_key) from aa_table = 344
I can't see how this would be causing a cross-join or anything like that,
and it has been working find with no modification for a lont time. Any
suggestions?
Thank you,
Noah Silva
IS&T - Programmer Analyst
(215) 419 - 7916
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
