Statistics

[Former Member]

Simple question today: I have just created a index on the PA2003 table

CREATE INDEX "SAPDEV"."PA2003~Z11"

ON "SAPDEV"."PA2003" ("MANDT", "AWREF", "PERNR")

TABLESPACE "PSAPDEV" PCTFREE 10 INITRANS 2 MAXTRANS 255

STORAGE ( INITIAL 16K NEXT 0K MINEXTENTS 1 MAXEXTENTS

2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)

LOGGING

ONLINE

The index I have created has not been analyzed and there is no statistics. What transaction would you use in SAP to analyze this index. I see nothing in SE11, transaction DB02 has Detailed analysis but nothing to acutally analyze a index.

Thanks for your time

[stefan_koehler · Accepted solution]

Hello Billy,

please use the BR*Tools (brconnect) for collecting statistics. There is also an ABAP report (RSANAORA) for that, but i would prefer brconnect.

Unfortunately you don't tell us your oracle version, but take a look at here:

=> http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5010.htm#SQLRF01209

> COMPUTE STATISTICS

>In earlier releases, you could use this clause to start or stop the collection of statistics on an index. This clause has been deprecated. Oracle Database now automatically collects statistics during index creation and rebuild. This clause is supported for backward compatibility and will not cause errors.

Regards

Stefan

[Former Member · Accepted solution]

Release 9.2.0.8.0 - Production

Stefan,

Thank you for your reply. Yes I use BR*Tools(brconnect) to collect statistics but you can collect statistics on a single index by:

• running tcode ST04

• detail analysis menu

• oracle session

• set filter by status ACTIVE

• cursor on status ACTIVE (choosing the SQL statement)

• hit display execution plan for SQL Statement button

• click on the Analyze button

• choose either table or index to analyze

I was just wondering if there was another TCODE in SAP that you can use instead of ST04 or brconnect to analyze and collect stats.

Thanks Stefan

Billy

[Former Member · Accepted solution]

Try program RSANAORA.

[former_member204746 · Accepted solution]

As Stefan Said:

SE38

program RSANAORA

you can also use tcode DB20.

[Former Member · Accepted solution]

Excellent everyone........thank you..........