topic Re: Improve the performance when adding new fields in an standard table in Application Development and Automation Discussions

Improve the performance when adding new fields in an standard table

Former Member — Thu, 04 Oct 2007 07:24:14 GMT

Hi,

In an standard table i added 3 new fields,After that the performance of Select query is reduced when i am using the table.How can i overcome this issue

Re: Improve the performance when adding new fields in an standard table

Former Member — Fri, 05 Oct 2007 09:10:36 GMT

Hi,

the performace of already existing selcts or select with a clause on the new columns?

If your select has something like

WHERE <newcolumn1> = 'ASDF' and <newcolumn2> = 'DummDilidumm'

you need to define a new DB - index over this columns.

Regards,

Gianpietro

Re: Improve the performance when adding new fields in an standard table

Former Member — Fri, 05 Oct 2007 12:37:54 GMT

hi lakshmi,

u retieve fields as u declare in internal table..

Eg:ur tables contains fields like..

data:begin of itab occurs 0,

name like zemp-name,

no like zemp-no,

dbt like zemp-dbt,

end of itab.

select name no dbt from zemp into table itab.

if possible use where condition it will retrieve the data fastly..

if useful reward the points...