on 10-16-2009 1:52 PM
HI ,
We have issue regarding indexes.They want us to set the value to 3.B tree level back to 3 for index 1 on HRP1001 .How to change it .Thanks in advance.
Hello,
note #724545 contains all the details. The corresponding command in sqlplus would look like this:
exec DBMS_STATS.SET_INDEX_STATS('<owner>','"HRP1001~1"', indlevel => 3, no_invalidate => FALSE);
Best Regards,
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.