a performance problem about query bseg, help,help

[Former Member]

thanks

we have a new report use such a sql which runs a long time:

SELECT bukrs gjahr bzdat anln1 bschl dmbtr

INTO CORRESPONDING FIELDS OF TABLE bsegtab

FROM bseg

WHERE gjahr = gjahr

AND bschl IN ('70' , '75')

AND anln1 IN anln1

AND meins = ''

AND anln1 LIKE 'G%'

AND hkont LIKE '1502%'

AND bzdat >= dat

AND bzdat <= dat1.

in se11,I can see bseg primary key is "mandt,bukrs,belnr,gjahr,buzei",and it is a cluster table.

Could I create an index on this culster table.

Could you give me some advices?

the environment is ecc6.0 and oracle 10g.

Edited by: victor on Sep 17, 2010 2:25 AM

Edited by: victor on Sep 17, 2010 2:25 AM

[Former Member · Accepted solution]

Hello,

Below link will be helpful.

http://wiki.sdn.sap.com/wiki/pages/viewpage.action?pageId=180356001

Regards,

Yoganand.V

[Former Member · Accepted solution]

thanks very much.

but how can I change my sql using these index tables. Could you give some advices to tunning this sql?

I do not know how to use these index tables.