A range-partitioned table on character-based partition keys can become suspect after a sort-order change, and hash-partitioned tables can become suspect after a cross-platform dump load.
Lists tables with suspect partitions.
sp_tab_suspectptn [table_name]
table_name – is the name of the table containing suspect partitions.
If you do not provide a table name, Adaptive Server checks all the tables in the current database.
If you provide a table name, Adaptive Server checks only the table named by table_name.
Any user can use this procedure.
sp_indsuspect
| Copyright © 2009. Sybase Inc. All rights reserved. |
|
|