TRUNCATEing a Table makes an UNUSABLE Index VALID again

(Hemant K Chitale) If you set an Index to be UNUSABLE but later issue a TRUNCATE TABLE, the Index becomes VALID again — i.e. the Index gets updated with rows subsequently inserted.

Read More - Register for Free Membership