Re: [PERFORM] Performance hit on loading from HD

2004-08-28 Thread Josh Berkus
Vitaly, > I have a problem with certain queries performance. Trouble is that > while their execution plan is pretty good and mostly their execution > is great as well, their FIRST execution time (that is after you mount > the database) is abysmal. This is a well-known problem. The general appro

[PERFORM] Performance hit on loading from HD

2004-08-28 Thread Vitaly Belman
I have a problem with certain queries performance. Trouble is that while their execution plan is pretty good and mostly their execution is great as well, their FIRST execution time (that is after you mount the database) is abysmal. I realize that it happens due to the loading of data from the HD t