Creation Parameter

SYSADMIN.createCreationParam

This procedure creates a creation parameter.

SQL

SYSADMIN.createCreationParam(
    "recOptId" => biginteger_recOptId,
    "paramKey" => 'string_paramKey',
    "paramValue" => 'string_paramValue'
)

If any option for the exact recommended optimization is already present in SYSADMIN.CreationParams, trying to add this option again with another value will cause an error. To edit an already existing option, please use the SYSADMIN.editCreationParam procedure described below.

SYSADMIN.editCreationParam

This procedure changes an existing creation parameter:

SQL

SYSADMIN.editCreationParam(
    "id" => biginteger_id,
    "paramKey" => 'string_paramKey',
    "paramValue" => 'string_paramValue'
)

SYSADMIN.dropCreationParam

This procedure drops an existing creation parameter:

SQL

CALL "SYSADMIN.dropCreationParam"("id" => biginteger_id);;