Demo file:  sql-multi-table-query-optimization.zip Recently a colleague requested help w/ a SQL query that was performing slowly. I wrote back: Make sure there are no records open locally, i.e., on your machine, in the tables you are querying (for more information see this article by Wim Decorte: ExecuteSQL – The Good, The Bad & The Ugly)… Continue reading SQL Multi-Table Query Optimization

View the full article