Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
System information: SunOS 5.9; R/3 4.7; Oracle 10.2.0.4;
Question: What is the best method to create indexes for very large tables?
Such as BSIS, 100 GB.
For example: Create an index named Z09 with fields: MANDT, BUKRS, HKONT
I know the normal answer is to use SE11 (create index, Z09) and then SE14 (build index, Z09). But this is where the problem lies. SE14 will LOCK the table until the index is created. Since the BSIS table is heavily used 24/7 in the system, this is not desirable. With little downtime available (2 hours a week maximum), this process will not work.
I understand that indexes can be created within SQL*Plus using the 'create index' command. But once this index is created, how is this index then linked to the table in the SAP database?
My attempt at this process shows:
- SE11 the index is listed and status is Active
- SQL*Plus created index using command of:
create index SAPR3.BSIS______Z09 on SAPR3.BSIS (MANDT, BUKRS, HKONT) nologging tablespace PSAPLARGEI parallel (degree 2) online;
- DB02 the index is listed with correct ownership and locations
But here is the issue:
- SE14 listed the index name, shows status as Active/Saved, BUT states "Does not exist in the database" and the DB Index Name shows as: "Not defined as DB index in the ABAP Dictionary". (Side note: All the Create/Delete/Activate buttons are greyed out). The Storage Parameters button shows no entry for the Z09 index.
Is there a missing step after the index is manually created to make it seen in the SAP system?
Is there a general steps procedure to use if creating index outside of the SAP transaction SE14?
Any help would be appreciated.
Thanks,
Larry
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight   _.____.__ |
