After finishing this , we can continue our series.We'll start with some background information of the column store that will help us to better understand the guidelines introduced by eric.westenberger.It is often mentioned that SAP HANA uses an „inse...
I recently delivered a service (ABAP OPEN SQL Optimization)for a customer and the customer asked me: “What’s the upper limit of indexesper table”. Three possible answers came immediately to my mind:32767; since that was the technical limit on that DB...
Try to remember, when was the last time you got a question andyou invested some time (and enjoyed it) to provide an answer? What were thecharacteristics of the question? Was it a specific or rather unspecific question?Was the question well prepared a...
Consultants or Support Consultants like me know this situation quite well: You are at a customer and you are asked to trace and analyze a background job which runs outside of office hours e.g. from 04:00 am to 04:30 am. This blog will show you how to...
The Single Transaction Analysis was extended recently and has some great new features. This blog shows you what you can expect from the latest patch. An overview of the new features is presented in this blog.Before you start:ST12 is delivered as a pa...
Hi,
Which will give better performance and why ?
Regarding the first part of your question:Try it out and write a little testprogram and meassure it with SAT and please share the results with us. If there is a significant difference we can continue w...
Hi,if you have to read the complete field there is not much you can do from an ABAP/SAP perspective. Maybe on database side (parameters, settings, caching, ...). If you have to process only parts check these links (Locators / Streams):http://help.sap...
Hi Peter,regarding buffered tables there is no change for the golden rules. We continue to use them like we did in the past. Local application server memory access (buffered table in-memory of the local application server) is still faster than remote...