DB02

[Former Member]

Team,

In DB02 transaction, on clicking tab ' Missing Indexes ', i need to diplay the primary index and secondary index count in abap report. So can you let me know if ant function module available or any standard reports to get this counts.

Thanks in advance.

Regards,

Gururaj.

[Arun_Prabhu_K]

Hello Gururaj.

     For primary index: Table DD03L (Pass TABNAME = table name and KEYFLAG = 'X' to get the count)

     For secondary index: Table DD12V (Pass SQLTAB = table name to get the count)

Regards.

[Former Member]

Hi,

Looked at these tables DD03L and DD12V.

But if i check DB02 transaction and click the tab "Missing indexes", the counts are different.

Attached the screen shot for reference. Here Primary index is 0 and Secondary index is 3.

i want to display only these 3 names in my report and if i cross check this this object name in DD12V for secondary index, the ibject does not exist in the table.

Please let me know how to get these counts.

regards,

Gururaj.

[Arun_Prabhu_K]

Actually I am not used to DB02 tcode functionality.

To get secondary index count of a table:

Just pass the table name to field SQLTAB of table DD12V.

I am getting the records correctly.

[Former Member]

Hi,

I'm not getting the counts correctly.  On clicking, 'Missing indexs, the counts for primary and secondary is different. Also i dont want to pass any table name specifically for field SQLTAB.

Anyways thanks for support.

Regards,

Gururaj.

[RaymondGiuseppi]

You could try to use native SQL commands, select from dba_tables or dba_indexes (After an analyze statement) Either use native SQL or an ADBC class CL_SQL*. Then cross the result with SAP ddic table like DD02L or DD12L.

Regards,

Raymond