Toad World® Forums

SQL pre-processing

A DBA is telling me that I am performing a SEL TOP 40 * FROM TABLE_A, except I am running a query with multiple JOINs. Is there some kind of pre-processing happening? How can I change this setting? Thanks!

Are you running a heterogeneous query? There most likely is pre-processing on each data source represented in the query.

We execute query "Select Top 40 * from tale_name" in code completion to provide column values for WHERE COLUMN_NAME = ... clause.

So every time when a user types WHERE column = we execute the query.

To avoid performance degradation user has to uncheck Tools | Options | Editor | Code completion | Include top values of column data

It appears we entered a code fix for this in TDP 5.0