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