When Updating a Column a very complicated SQL is generated and executed
说明
After updating one field in a table, once the field data is overwritten and the refresh button clicked, a complex sql statement is generated and cannot be cancelled.
原因
The problem with this is that DB2 is not using their index even though the SQL generated is using the key fields. We think this is more of a DB2 problem rather than a Toad problem. Anyway we have opened a CR to investigate this.
解决办法
WORKAROUND
None
STATUS
Waiting for fix in a future release of Toad for DB2 ZOS
