Query Run Time
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Query Run Time
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.
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Query Run Time
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.
In general, there is no way to know in advance how much time a query will take to run.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 627
- Joined: 03 Feb 2010, 15:02
Re: Query Run Time
I didn't think so but I figured if anyone would know, you would.