Hi Everyone,
I've got the following problem :
On a production system, a program is slowed down a lot (25% more).
The only change we did in the program is adding a field in a selection.
How will the buffer behave after this kind of change ?
I know that in ST04, we will find a new SQL-ID for the new query. but what will it do with the buffer, will it start again to put database data in buffer hence slowing down the query ?
My query is a join between two huge tables (almost 500M entries each)
Maybe the use of "for all entries" instruction doesn't help ?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.