A quick one: >From SQLStudio, run the command "explain YourQueryHere..."
That will tell you if there are tablescans, which are first candidates for performance problems, armed with that information you can create indexes to solve the problem. When things get more dificult to diagnose, turn on the analyzer for a while, it will print some warnings that will guide you to potential causes for performance problems. Hope it helps. Regards, Martin Cordova -- Dinamica - RADical J2EE framework open source, easy and powerful http://www.martincordova.com On 4/7/06, Daniel Castro <[EMAIL PROTECTED]> wrote: > Hi, > > I am newbie in SAPDB issues. > I would like to know which steps do I have to take to identify sapdb > performance problems. > I am having a serious performance problem and even though I executed > "sql_updatestat * ESTIMATE SAMPLE 100 PERCENT" > the problem is not solved. > > Thank you very much. > > -- > Daniel Castro > Website: http://danielti.no-ip.info:2139 > MSN: [EMAIL PROTECTED] > Skype: danielti2005 > ICQ : 316727989 > Jabber: danielti > Linux User: 387864 > AOL User: Danielti2005 > Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
