Query Run Time

matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

Query Run Time

Post by matthewR »

I have a query that has been running a long time. Is there any way to tell how much longer a query will run? I was thinking maybe the task manager. I don't really understand the task manager to interpret what it is conveying.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Query Run Time

Post by HansV »

No, the task manager can only tell you how much CPU power Access is currently using and how much CPU time Access has used since it was started, but it can't look into the future.
In general, there is no way to know in advance how much time a query will take to run.
Best wishes,
Hans

matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

Re: Query Run Time

Post by matthewR »

I didn't think so but I figured if anyone would know, you would.