Use Microsoft Jet's ShowPlan to write more efficient queries
While reading some posts on the Access newsgroup, I came across this article about optimizing your Access queries. One of the most powerful features of SQL Server is being able to view the execution plan of a query. With this relatively simple registry hack, you can accomplish a very similar feature in Access, by forcing Access to export the execution plan to a text file.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment