Danny Tramnitzke wrote: > I have a BIG SQL Statement, which takes more than a half hour > to got the > result (so, after a half hour I stopped the process..) > I guess, to post the hole sql it self, makes not big sence, > but I post the > explain output: > ... > > So, it is possible to imagine the time, which sapdb needs to > execute the > statement, by reading this Explain ? > > It's strange, that sapdb needs so much time, because, in > Sybase, this SQL > takes just a few Seconds. > > Because, there might be a format error while transfert the > email, I attach > a text-file with formated Output of the EXPLAIN Statement..
If not already done please update the optimizer statistics of all involved tables with the update statistics command. Additionally you could try to change the database parameter JOIN_MAXTAB_LEVEL4 to 20. This will result in an other join sequence search strategy and perhaps to a better join sequence. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
