How to stop Toad from executing "SELECT TOP 40 FROM" queries? (4227423)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

How to stop Toad from executing "SELECT TOP 40 FROM" queries?
Description

No errors, just a question.
When using Toad Data Point (TDP), and, using a monitoring tool to track down what it executes in the server, one may see it executes a lot of statements like this:
SELECT TOP 40 FROM <Table_Name> ...
Where are those queries being created? Is it possible to stop TDP from executing them?
Cause

When TDP's "Code Completion" is active, it generates queries like "Select Top 40 * from Table_Name", in order to provide column values for the "WHERE COLUMN_NAME = ..." clause.
So, every time when one types "WHERE column = ...", TDP executes the query.
Resolution

This behavior is by design, and one can chose to have this option on, or to turn it off.
To avoid the generation of these SQL-Queries, one has to uncheck:
Tools | Options | Editor | Code completion | Include top values of column data

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title