Partial Indexes–Take Care With Truncate

(Connor McDonald) Partial indexes are a very cool feature that came along with Oracle 12c. The capability at partition level to control index existence allows for a couple of obvious use cases:

Register to Read