05-14-2009 10:03 PM
Hi,
We have changed the index 3 on the table GLPCA and transported the same. Now we are trying the activate the index and arrange the records for the change. The job started for the same and it is continuing to run since 3 hours.
Is there a way we could know how many entries are available in GLPCA and estimate the time.
Is there a tcode in SAP that would give the number of entries in GLPCA . The option SE11 -
> Number of entries is going to dump. So we need some other option.
Regards,
Prabaharan
Moderator message - Moved to the correct forum
Edited by: Rob Burbank on May 14, 2009 5:08 PM
05-14-2009 10:07 PM
First of all - you have created and activated the index, but have you created it in the database?
Rob
05-14-2009 10:24 PM
Check wether tx DB20 tells you the number of records.
Thomas
05-15-2009 8:05 PM
We created the index in SAP. We are trying to activate the same in the Database and the job is running for long.
Regards,
Prabaharan
05-15-2009 8:08 PM
Hi ,'
check the index it is using in DB05 ..
if the program in not using the right index..
try to force the index by using Index Hint..
or
check if the Index is not active properly and if u want to force the index in the program using index hint..
the program goes to dump..
first try to activate the index in background..through ..go to table--select the index >utilites>datatbase utility--
-->activate and adjust data base in background...
Regards,
Prabhudas
05-15-2009 8:12 PM
Did you activate the index in SE14?? Did you update the statistics for the table after the index was created?
Rob
Edited by: Rob Burbank on May 15, 2009 3:17 PM
10-16-2009 4:36 PM