In Toad v6.8, when querying any database the first time it takes a long time return the result set. Subsequent queries then run faster.
说明
In v6.8, when querying any database the first time it takes a long time to return the result set. Subsequent queries then run faster. When afterwards querying a different database on the same server, the first time it again takes a very long time, compared to the second run of the query.
原因
The problem lies in the highlighted sub-select on sys.dm_db_index_usage_stats which Toad queries. Toad is reading alot of information from the database before performing the query. The query speed varies depending on the size of the database.
解决办法
WORKAROUND: The issue does not occur in v6.7
STATUS: Waiting for fix in a future release of Toad for SQL Server.
