reg index

[Former Member]

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.

[Former Member · Accepted solution]

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