on 11-07-2008 4:57 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.