Skip to Content
0
Former Member
Sep 23, 2010 at 12:23 PM

Rebuilding BSAD~Z01 index

22 Views

Hi,

Finally I have decided to add some more fields in the existing BSADz01 index to improve performance. Currently BSADZ01 index is picking from select statements. What are the precautions to take for adding some more fields to this index. Whether it will effect any other programs about data load or not. How can i proceed further. Its giving problems in PRD because of taking more time.

SELECT specific fields FROM bsad

into table gt_bsad

WHERE bukrs = docs-bukrs

AND gjahr = docs-gjahr

AND augbl > docs-low

AND augbl <= docs-high

AND zlsch = docs-meth.