Syntax
alter_option
depends on the operation you want to perform on the index. For all supported clauses, see the sections below.
Clause
RENAME TO
Parameter or clause | Description |
---|---|
RENAME TO | This clause changes the name of the index. If the index is associated with a table constraint (either UNIQUE, PRIMARY KEY, or EXCLUDE), the constraint is renamed as well. There is no effect on the stored data. |
new_name | The new name of the index. |
SET PARALLELISM
Parameter or clause | Description |
---|---|
SET PARALLELISM | This clause controls the degree of parallelism for the targeted streaming job. |
parallelism_number | Can be ADAPTIVE or a fixed number (e.g., 1, 2, 3). Setting it to ADAPTIVE expands the job’s parallelism to all available units, while a fixed number locks it at that value. Setting it to 0 is equivalent to ADAPTIVE . The maximum allowed value is determined by the max_parallelism of the job. For more information, see Configuring maximum parallelism. |