Skip to Content
Former Member
Jun 29, 2011 at 02:19 PM

It worsens performance of a query after a modification in his definition


Hi Gurus,

Yesterday a few modifications in a query.

I him added more filters in a structure that exists in the lines of the query, beside adding algun ratio restricted and calculated in columns. Also I used the usefulness of cells since the calculation of a ratio is not common for all the celdas.

Once effected these modifications, the performance of the query to worsened, it does not stop executing giving a dump for time-out of execution.

Can you say to me if there exists some way of knowing that concrete new elements defined in the query (filters, ratios, cells) could have caused the above mentioned deficiency?