Dear experts.
We have some programs (Z) making high costing accesess to some tables, related with this, for some tables we create new statistics in a daily basis (MSEG, PRPS and so on..) the problem is that some days (not always) those programs degradate drastrically and we need to re-create statistics in order to recover normal performance.
The question we want to ask is that any of you have had this behaviour before and found (or know) any reason for it.
Could you please give us some hint about this (strange) issue?.
Hope you could help us.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.