Creation Parameter

SYSADMIN.createCreationParam

This procedure creates a creation parameter. If any option for exact recommended optimization is already resent in SYSADMIN.CreationParams, trying to add this option again with another value will cause an error - to edit already existing option please use SYSADMIN.editCreationParam.

SQL

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

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);;