creating Index in Oracle database

[Former Member]

What is the best way to create Index for table in Oracle database. here we are using oracle version 92050 with SAP R/3 4.6c.

I have to create following index :

BSID~3 on thedatabase for tables BSID and BSAD.

Regards

Amar

[Former Member · Accepted solution]

Hi,

I hope this is solved.If yes please close thread.

Regards

Vinod

[Former Member]

Hi,

Indexes should generally be created using SAP tools (in other words, transactions SE11 and SE14, transports) in the SAP environment.

If required, you can also create an index at Oracle level using the command CREATE INDEX. Here, additional options such as PARALLEL, NOLOGGING or ONLINE are possible.See also Notes 806554 and 334224 regarding this topic.

Regards

Vinod