on 03-18-2009 11:14 AM
Dear Experts
When i chk the update optimizer statistics, there are 26 missing indexes, please help me how to rebuild the missing indexes.
regards
varun
Hi,
You need to run update statistics either using brtools or sqlplus.If these indexes are missing from database side ,use t-code se14/se11 to recreate these on DB.
Let us know after checking above mentioned points.
Regards,
Gagan Deep Kaushal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Completely missunderstood the question, indexes can be rebuilt by using instructions above.
You can also use Brtools to rebuild indexes...
Read,
http://help.sap.com/saphelp_nw70/helpdata/en/75/95536a63b44b4a9e7f278c7d9c2b67/frameset.htm
Regards
Juan
You can rebuild statistics using brconnect at OS level,
brconnect -u / -c -f stats -t <tablespace> -f collect -p <number of parallel processes>
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
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.