SE14 or SE11 Create index

[Detelin_Nedev]

Hello guys,

I wonder how SAP creates an index when it is executed via SE14 or SE11 transactions. I mean on Oracle level and especially ONLINE option. My consideration is that I must create an index on a big table and the duration is around 5+ hours. We tested this in a fresh test environment (copy from productive system). Unfortunately we cannot lock the productive system for so long period. So, if index creation is with ONLINE option - it will not lock the table and it will be used if necessary.

Thank you for your suggestions and advices.

Best regards,

Detelin

[anindya_bose]

Hi

I guess you can create online i.e when the system is running from SE11.

Please check the link

Link: [http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eb47446011d189700000e8322d00/content.htm]

[Detelin_Nedev]

Hi Anindya,

Yes, this is my intention, probably I was not very clear. I mean whether the SAP system passes the create index statement on Oracle level with ONLINE option.

CREATE INDEX ... ONLINE ...

Best regards,

Detelin

[anindya_bose]

Hi Detelin

No, during index creation database locks the table. So, although your SAP is up particular table will be locked for deletion , insert etc.

But from oracle level you can create index online by running SQL command

Please refer to note Note 334224 - Important notes for creating indexes

Regards

Anindya

Edited by: Anindya Bose on Mar 4, 2010 6:57 PM

[Detelin_Nedev]

Hi Anindya,

Yes, it really helped me. Thank you, very much!

Best regards,

Detelin