Subject Re: Query is running slowly for the first time.
Author un_spoken
> So how do you fix the problem, given that you will have to run the
> procedure with different parameters? Increase the amount of system memory.
> Get a faster disk. Increasing the page size so you don't have to do as
> many random page reads on disk may help too.
>

Thank you Ann for explaining me this. I think I will start with increasieng the page size to 8 or 16 kb as Tomas suggested. However, what are the drawbacks of this increament? There must be some, otherwise it would be setup bigger from the begining.