Skip to Content
0
Former Member
Jul 02, 2009 at 04:08 PM

table query taking long time

34 Views

Hi friends,

Custom program takes long time at a select statement now. It used to work perfectly fine before. Query is as below.

Select field1 field2 field3 field4 from <TAblename> into (tablename-field1 tablename-field2 tablename-field3 tablename-field4) UPTO 1 rows where pkey2 = 'XXXX'.

Can anyone you suggest what could be the problem.

Thanks in advance.