An Experience with SAP TechED’06 Session at Bangalore – BIM205 Little tweaking of famous quote “He came he saw and he conquered” will display my experience at TechED’06 Bangalore…. In my case it truly was “I went I saw and I was floored….” TechEd’06 was an event very well managed and presented a lot of learning opportunities for lesser mortal like me…Amid that entire hullabaloo I had managed to deliver my session (Thanks to SDN jury and each one of you who voted for it) - BIM 205 “Getting Through the Maze of Query Performance – a Quantitative Approach”. I went into the session with the intention of presenting a new perspective on Query Performance and at the end of it, I myself ended up having an altogether new perspective to Query Performance. Especially the post session discussion made my grey cell working overtime; I was compelled to think about certain obvious things which I conveniently managed to skip over all the past years. I am still grappling for answers & would appreciate your thoughts on below mentioned points – 1.Ratios of times – I talked about three important time components of Query Execution Database Time, OLAP Time & Front End time, is there a ratio (optimized), which is recommended for these time. For example if I say my query execution time is 100 sec & ratio of these times is 30, 30 and 40. Is that the best distribution among times? 2.Sequence of optimizations – What is the best sequence of optimizations steps – which one I should optimize first Database, OLAP time or Front-End? My suggestion was to start with recognizing the culprit among these components & start with most time consuming part. Any more suggestions? 3.Efforts trade off – Another point I mentioned make sure that you are aware of trade off involved of any action taken in order to improve query performance, for example if you decide to create Aggregates for query performance then also take added maintenance efforts into consideration. Question is – Is there a way to quantify this trade off? And there were many more… which I can’t recall as of now. Before I sign off, I shall like to thank every one, who attended the session and helped me in developing a new perspective towards Query Performance. IT WAS AN EXPERIENCE BEYOND WORDS!!!
