Wednesday, June 1, 2011

Command to Rebuild Indexes

We used the following command to rebuild the indexes in ZE1 System :

brspace -f idrebuild -i (index_list)

For eg :

brspace -f idrebuild -i /COCKPIT/THDRV~DEL

behind the scenes, it is using the below sql command :

sql) alter index "SAPEVO", "/COCKPIT/THDRV~DEL" rebuild online;

in generic terms

alter index "(schemaname)", "(indexname)" rebuild online;

No comments: