Oracle forms - LOV - Low performance in dynamic filter (not “search” field but by typing character)

Hello,

In Oracle Forms, I have trouble about Low performance in dynamic filter (not “search” field but by typing character when focus is in the list) of LOV

I have a table MY_TABLE with about 150000 records.

I make a LOV on this table (with jointure with two others table), the LOV contains 4 columns:

- MY_ID VARCHAR2(9)

- OT VARCHAR2(50)

- ETAT VARCHAR2(50)

- DES200 VARCHAR2(200)

Note: most MY_ID are like ‘FT%’, (generally MY_ID format = FTYYxxxxx where YY is the year of the creation date and xxxxx is a sequence number)

At the execution the entire LOV is long to appear (but it’s normal, 152823 rows).