Hi,
more detais needed.Do all with same connection
1. Connect to db2. Run query without where clause
SELECT
A.cd_xxx, A.dt_1, A.dt_2, A.dt_3, A.dt_4, A.dt_5, A.dt_index
FROM DM251 A
3. Run query
SELECT
A.cd_xxx, A.dt_1, A.dt_2, A.dt_3, A.dt_4, A.dt_5, A.dt_index
FROM DM251 A
WHERE A.DT
Hello.
I created an index on a table where de column is datetime type. The problem
seems to be related to the NULL value.
This SQL is very SLOW (about 7 seconds for a table containing 360.000 records).
Returns around 400 records
SELECT
A.cd_xxx, A.dt_1, A.dt_2, A.dt_3, A.dt_4, A.dt_5, A.dt_ind