Noah J SILVA wrote: > 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?
You really mean no modification? No update statistic run on the involved tables? No additional data in the tables? Could you please post the explain plan of the query. Please use "explain view" command then the explain shows the real table names instead of the view name. Best regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
