Enhanced parallel create index is disabled by default, and is part of the enable functionality group configuration parameter. To enable Adaptive Server to use parallel create index:
Enable the enable functionality group configuration parameter:
sp_configure "enable functionality group", 1
Set the database option select into/bulkcopy/pllsort to true:
sp_dboption database_name, "select into", true
Set the following configuration parameter according to your hardware environment:
number of worker processes – set to the maximum number of concurrently executing parallel threads used by all users
max parallel degree – set to the maximum parallel degree used for an individual user, but not higher than number of worker processes
max online engines – Sybase recommends that you configure a sufficient number of engines when configuring parallel threads, depending on hardware avaialbility and other workloads. number of worker processes is typically set higher than number of engines