Don Hayes wrote: > I have a case where the joining fields are fixed 6. The performace is extremely >slow. > I originally wrote this in MSSQL2000 and it worked reasonably, like only a couple of >seconds on a slow PC. > In SAP 7.4.3beta it takes 10 seconds for 60 rows even on a speedy box. > > Excerp: > > SELECT patronrelations.PRIMARYPATRON, > patronrelations.SECONDARYPATRON, > patronrelations.VERIFYEXPIRATION, PATRONS.* > FROM DBO.PATRONRELATIONS patronrelations > INNER JOIN DBO.PATRONS PATRONS ON >patronrelations.SECONDARYPATRON=PATRONS.PATRONID > > where patronid and secondarypatron are the fixed 6 fields. Any issues about numeric >joins? > I have tried adding indexes on all the joining fields which usually improves >performance > greatly but not in this case.
Perhaps an update statistics on the involved tables helps. If not please send me the explain output. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
