If you’ve played with the ODBC link in QuickBooks (QODBC) that allows you to extract data for reporting, etc., then you know that it’s pretty powerful. You have probably also realized that some queries can run very, very slowly. In this case, there’s an “optimizer” that will speed up queries and reduce the load on the QuickBooks database.
In our tests on large QuickBooks Enterprise databases, the increase in speed is pretty amazing.
However…if you have to rebuild the QuickBooks database, you’ll find that you need to redo the optimization (rebuild the optimization database). As much as we may not like it, this is a “feature” of QuickBooks ODBC link.