|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
RE: SAPDB Performance very low with big sql Statement
From: Becker, Holger (holger.becker
sap.com)
Date: Thu Jul 03 2003 - 08:09:08 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]