Transaction for getting Table and index information

[benoit-schmid]

Hello,

From st05 -> Analyse -> Click on a table or index, I get a window that is labeled table and index information.

Is there a transaction that allow me to have this information for other tables?

Thanks in advance for your answer.

[Former Member]

In R/3 , db02 --> third tab Tables and Indexes

Regards,

Kiron.

[markus_doehr2]

SE14?

Markus

[benoit-schmid]

Hello,

I did not find it in se14.

I am interested by the analyze results.

Thanks in advance for your answer.

[benoit-schmid]

Hello,

In db02, I did not get the info with number of distinct for column and the number of distinct keys found by the statistics updates.

I am interested by these informations.

How could I get them?

Thanks in advance for your answer.

[Former Member]

Hi,

Try from Tcode, st10, then click on today and click on show statics, then in next screen you will find Analyza Table tab, in that you can fill the required information and check.

hope this will helps you to get your information

Thanks,

Kiron.

[benoit-schmid]

Hello,

With st10, I could not get the information too.

Thanks in advance for your answer.

[Former Member]

Well since you are in ST05 already, choose "enter SQL statement":

select * from <your_table> -> explain

Cheers Michael

[benoit-schmid]

Hello mho,

I have tried

-> st05

-> Click on Enter SQL Statement

select * from bpcg where wrttp in '43' and geber in 'DIP';

-> Click on explain

Then I have the following error: Error received from Explain SQL

Message no. 0S033

Would you know what I am doing wrong?

Thanks in advance for your answer.

[Former Member]

You must not use the semicolon ( at the end!

Cheers Michael

[benoit-schmid]

Hello,

Thanks for the info.

It works.

I close the call.