Code Completion “Include Top 20 Values of Column Data” Causes Slow Performance in Toad for Db2 (4209117)

When the option "Include top 20 values of column data" is enabled under Code Completion settings, Toad executes background queries to retrieve sample data for columns.

Observed behavior:

• Code completion becomes slow or unresponsive
• Background queries take excessive time to execute
• System resource usage increases significantly

Example query executed: SELECT DISTINCT("column") FROM "creator"."table" FETCH FIRST 20 ROWS ONLY WITH UR FOR FETCH ONLY

In reported cases:

• Elapsed time: 27,712 seconds
• Getpages retrieved: 4,079,997,504

There is currently no workaround available while keeping this functionality enabled.

Recommended actions:

1. Disable the option if possible:
   • Go to Options → Editor → Code Completion → General
   • Uncheck Include top 20 values of column data
2. Restart Toad if needed.
3. Verify that code completion performs faster without the option enabled.

Note:

• If organizational policy requires this option to remain enabled, the performance impact cannot be avoided at this time.