Just for those who are interested, on a dual processor WIn2000 machine with 2 gig of RAM:

Once in cache it takes only 6-10 seconds (single user) depending on the parameters...

Thanks for the reply Andy. Before i go on i must add a disclaimer that this is not my system i have been asked to get it up and...

Brian,

Thanks for the reply. I wish i knew, i'm pretty sure something is being aged out and have assumed it was the execution plan as the data is not...