FORMS -> RECORD GROUP -> LOV,.... Using indexes

[Quoted] Hi there,

My table (20.000 rec) contains customers like:

CUST_ID
CUST_NAME
CUST_ACTIVE   ( 'Y' OR 'N')

In forms I made a lov to lookup an customer using it's name (and only those customers who have CUST_ACTIVE='Y').
[Quoted] When I call the LOV it takes much time before it's displayed, so I thought about using index.

I made a index CUST_NAME_I (cust_name) on the table and wrote sql like:

SELECT /*+ index(CUST CUST_NAME_I) */ CUST_ID, CUST_NAME FROM CUST
WHERE ( (CUST.CUST_ACTIVE = 'Y') )
ORDER BY CUST_NAME ASC but still the performance is poor.....

Please help....

Best regards,
Stephan Received on Tue May 01 2001 - 11:59:07 CEST