Improve the performance when adding new fields in an standard table

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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...