GLPCA table indexing issue

[Former Member]

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

[Former Member]

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

[Former Member]

First of all - you have created and activated the index, but have you created it in the database?

Rob

[ThomasZloch]

Check wether tx DB20 tells you the number of records.

Thomas

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

It was a helpful answer.