Hi all, we have resolved the problem using your suggestions.

The solution have appeared updating statistics with each RAM memory amount configuration. We thought that the update statistics process is necesary...

1.- I will try that now.

2.- Yes, it is. Several executions of the query has same time to obtain results.

Sorry, I've duplicated the previous post because I haven't seen the...

1.- I will test that now.

2.- Yes, it is consistent. Always shows the results in same time lapse.

There aren't two machines... It's the same virtual machine with 512Mb, then shutdown, reconfigure with 2Gb and execute de same query...

Thank you.

Hi Grant, thank you for your answer.

I give you some information about de problem:

Virtual machine name: CLON-DCDB02

The following query is one of the problematic queries:

select * from

(...

Hi. Thank you very much for your responses.

After a lot of tests in production and test environments, the result is that when we change the amount of RAM memory (only...