Adaptive Server provides several tools for working with sort behavior:
set sort_resources on shows how a create index command would be performed, without creating the index. See “Using set sort_resources on”.
Several system procedures can help estimate the size, space, and time requirements:
sp_configure – Displays configuration parameters. See “Configuration parameters for controlling parallelism”.
sp_helpartition – Displays information about partitioned tables. See “Getting information about partitions” on page 111 in Performance and Tuning: Basics.
sp_helpsegment – Displays information about segments, devices, and space usage. See “Checking data distribution on devices with sp_helpsegment” on page 114 in Performance and Tuning: Basics.
sp_sysmon – Reports on many system resources used for parallel sorts, including CPU utilization, physical I/O, and caching. See “Using sp_sysmon to tune index creation”.
