Subscribe to Windows IT Pro
October 24, 2001 12:00 AM

Estimating a Query’s Runtime

SQL Server Pro
InstantDoc ID #22566
Rating: (0)

In SQL Server 2000, can you see a query's runtime without executing the query?

You can produce an estimated showplan, but it won't necessarily return actual time figures. Instead, the showplan displays the query optimizer's time estimate from a reference computer (which might be one of the team members' machines in the SQL Server development group).

Related Content:

ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here

advertisement

advertisement

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.