Originally posted by AJW_ID01
1. How would one manually 'set' an index to unusable state? {I've only ever effected that during table moves before . . . .}

2. What exactly IS the benefit on a rebuild, as opposed to a build from scratch?
- Tony.
1) Alter Index idx_nm unusable;

2) nothing.

Abhay.