Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
