db02 & indexes

[Former Member]

Hi,

I would like to know where do i find information regarding my system's indexes?

I'm runing and upgraded system of ecc6 (before was 4.6c) with sql server 2000.

on the earlier system - 4.6c i had to goto transaction db02 ->db analysis-> missing indexes and there i had all the information i needed plus the opion to create missing indexes in the db - but in ecc6 in db02 i can't find - can anyone assist?

Regards,

Moshe

[Former Member]

To other people who had the same problem,

on the item list on the left pane

SPACE -> Segments -> Detailed Analysis(Aggregated) -> enter the object name and execute.

It will display the object selected on the right pane

you may have to double click (and wait for awhile) before the data about the table(including indexes) will be displayed below.

Had the same situation earlier

Edited by: Wilfredo Sepulchre on Mar 21, 2010 12:14 AM

[Former Member]

Dear friend

See the option

goto transaction db02 ->GOTO-> missing indexes

Shailesh Tiwari

[JPReyes]

Hi Moshe,

Just go to DB02 and click on "Missing Indexes", 3rd button from the bottom.. or click on goto -> Tables and indices -> Missing indexes

Regards

Juan

Please reward with points if helpful