Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

Create Indexes for Batch Run

The Create Indexes for Batch Run window displays when you execute the Batch Run or Batch Show Plan function. It enables you to specify how you would like the indexes created:

Item

Description

Segment

Select the segment where you would like the index created from the drop-down list.

Consumer

(Default 1 Range 1-20)

Specify the number of consumer processes that should perform the sort operation for creating the index. The actual number of consumer processes used to sort the index may be smaller than the specified number, if fewer worker processes are available when Adaptive Server executes the sort.

 

Related Topic

Related Documents