Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Thanks Snowy for the reply.
Unfortunately at least in my case, the process takes much longer than two hours.
This was tested in a copy of the production system (QAS) and the create process using SE14 for the Z09 index took more than 16 hours to complete.
The QAS system is similar to Production (SunOS/16 CPU/67 GB RAM, 25% utilized) and still took 16 hours to build.
The production SUN system this is running on has 12 CPU; 83 GB RAM; and is normally only 50% utilized.
I am looking for a different method to create large indexes on large tables.
OSS Note 334224 shows the SQLPLUS method to create the index, but nothing about the issues I described in getting the SAP system to recognize the index.
| | | ---------------Original Message---------------
From: Snowy
Sent: Friday, October 07, 2011 11:39 AM
Subject: Best Method to Create Index For Large Tables
Hi,
Two hours is more than enough to create that Z index.
Test this in a non-prod system and you will see that this should take less than 30 minutes. |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Popular White Papers
In the Spotlight   _.____.__ |
