ER: Show Unusable Indexes where one of its its
Partitions is Unusable
Hi Richard,
Sorry I didn’t respond to this sooner. This information is available
already in SB-Indexes-RHS (or Describe window) Partitions tab. If a partition is
unusable, you’ll see a red X next to the partition name in the grid.
It’s also brought to your attention in the alter index dialog, and
it’s in the ‘Invalid Objects’ tab too.
-John