Adaptive Server’s management of partitioned tables is transparent to users and applications. Partitioned tables do not appear different from nonpartitioned tables when queried or viewed with most utilities. Exceptions are:
If queries do not include order by or other commands that require a sort, data returned by a parallel query may not in the same order as data returned by serial queries.
The dbcc checktable and dbcc checkdb commands list the number of data pages in each partition.
See the System Administration Guide for information about dbcc.
sp_helpartition lists information about a table’s partitions.
showplan output displays messages indicating the number of worker processes uses for queries that are executed in parallel, and the statistics io “Scan count” shows the number of scans performed by worker processes.
Parallel bulk copy allows you to copy to a particular partition of a heap table.