If you change the sort order, Adaptive Server marks range-partitioned tables with character-bd partition keys as “suspect” in sysindexes. These restrictions apply when you run commands on tables that are marked suspect:
You cannot run DML commands or use cursors with partitions marked “suspect.”
You can run commands like select on tables marked “suspect,” but the query processor treats these tables as round-robin partitioned tables, so optimizations using partition conditions such as “partition pruning” do not apply.
The only alter table command you can run on partitions marked suspect is alter table...repartition.
You cannot create index on | from or drop index on | from on tables marked with suspect partitions.
You can fix tables with suspect partitions using:
alter table...repartition – if you need to change the partition condition after a sort order change, or
reorg rebuild – if you know the partition condition is correct.
When a table is marked as having suspect partitions and suspect indexes, you can run alter table...repartition or reorg rebuild to fix the partition and the index.
