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

you might looking at putting an index by the active flag first, then customer name.

How do you have the lov set up, it should only fetch 20 records at a time. Also you can pre-filter the lov in order to help the search. Using this method with an index of active_flag, cust_name should help

"S van Hoof" <stephan_at_hoof.nl> wrote in message news:9cm19f$lk3$1_at_news1.xs4all.nl...
> 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').
> 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 - 14:21:46 CEST