Crash due to long sql

[expired user #8063]'s profile image [expired user #8063] posted 10 years ago in General Permalink
Hello, this is a problem that needs to be sovled:
When I choose a table that is very large in the left panel, and in "data" tab I execute "col = XX" in filter, and col is not indexed, the whole ide crashes, and the stop button is in grey state.
But this is not the main problem. Next time I click the same table, select the data tab, the sql is executed automatically!!I don't have the chance to remove the filter sql.DBA has been angry about my long sql executed twice a day.
Thanks.
[expired user #8063]'s profile image [expired user #8063] posted 10 years ago Permalink
Can data filter query be executed manually rather than automatically when user select data tab?
ansgar's profile image ansgar posted 10 years ago Permalink
You can clear that filter *before* activating the data tab:

Before doing that, just make sure you don't have the data tab already activated, as the rightclick also activates that table.
[expired user #8063]'s profile image [expired user #8063] posted 10 years ago Permalink
The sort filter can not be cleared.
ansgar's profile image ansgar posted 10 years ago Permalink
Yes, that's right. Although I thought you were talking about the WHERE filter. But I guess it's a good idea to clear the ORDER BY clause as well with that menu item. Also the selected/unselected columns should be reset in that action.

Please login to leave a reply, or register at first.