topic Re: how to correct error in Application Development and Automation Discussions

how to correct error

Former Member — Tue, 06 Apr 2010 10:48:15 GMT

i am getting error like " large table zvtpmheader : no field of a table index in where condition in code inspector for one of my report.

please tell me what is the problem and how to solve it.

code is like below,

SELECT prgnumb prgtype descript requestor FROM zvtpmheader "+JK01

INTO TABLE t_zvtpmheader "+JK01

WHERE requestor IN s_inireq AND "+JK01

requestor NE p_chareq AND "+JK01

prgstatus = 90 "+JK01

ORDER BY prgtype prgnumb.

Re: how to correct error

Former Member — Tue, 06 Apr 2010 10:52:30 GMT

you have to use at least one primary key field in the WHERE condition. Ideally you should use any one combination of the INDEXES available for that table.

This is suggested interms of performance.

Re: how to correct error

ThomasZloch — Tue, 06 Apr 2010 10:55:55 GMT

Vague subject, plus the message is somewhat clear, isn't it? Please study the longtext for that message and search for basic concepts like "table indexes".

Thread locked

Thomas