Dragan,
As Ed and Ellen said this is definitely 'real'. I've done this myself, particularly in reporting where users may be running a series of "end of month" or "Year end" reports on the same data.
Barbara
>I'm taking the opportunity to check my general rule of thumb for slow SQL Selects. Here it is:
>
>If your Select involves more tables, possibly a few joins, pick the largest one of them and select from it into a cursor first. Then work with that cursor - don't do any joins on a large table.
>
>I don't know if anyone was trying this out, but I've had cases which were sped up just by selecting from a large table into a cursor in a select where no other tables were involved (like taking out the needed month out of a few years of history data) and then stuffing that cursor into further selects with joins etc. The speed gain was even five or ten times in some cases.
>
>If someone had similar experience, I'd like to shed some light on the issue. What I'd like to know is whether this is a general rule, or it has its ups and downs, or was I just plain lucky in these cases.