Code Completion 'Include top 20 values of column data' which is taking a long while. (4209117)

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

Code Completion 'Include top 20 values of column data' which is taking a long while.
Descripción

Problem with the code completion option:
When in Options, Editor, Code Completion, General, box 'Include top 20 values of column data' is selected then queries like this will be executed in the background:

SELECT DISTINCT("column") FROM "creator"."table" FETCH FIRST 20 ROWS ONLY WITH UR FOR FETCH ONLY
Causa

When large tables are involved this query takes a long while
In user’s case -
27'712 seconds of elapsed time
4'079'997'504 Getpages retrieved

This can of course be avoided when this option is not selected. But in a large organization it is not possible to avoid this from being used.
A solution can be achieved if the select in the background query does not contain the distinct parameter which would make the query much faster.
Resolución

WORKAROUND

NA

STATUS

Waiting for fix in a future release of Toad for DB2.
ID de defecto

TDB-4094

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Historial del artículo:: Creado el: 8/22/2022
Última actualización: 5/7/2023

Título