Alter SAI index
SAI indexes cannot be altered. If you need to modify an SAI index, you must drop the current index and create a new one.
Prerequisites
-
-
Drop indexes.
DROP INDEX IF EXISTS cycling.lastname_idx; DROP INDEX IF EXISTS cycling.age_idx; DROP INDEX IF EXISTS cycling.country_idx; DROP INDEX IF EXISTS cycling.registration_idx;
-
Create new indexes.
CREATE CUSTOM INDEX lastname_idx ON cycling.cyclist_semi_pro (lastname) USING 'StorageAttachedIndex' WITH OPTIONS = {'case_sensitive': 'false', 'normalize': 'true', 'ascii': 'true'}; CREATE CUSTOM INDEX age_idx ON cycling.cyclist_semi_pro (age) USING 'StorageAttachedIndex'; CREATE CUSTOM INDEX country_idx ON cycling.cyclist_semi_pro (country) USING 'StorageAttachedIndex' WITH OPTIONS = {'case_sensitive': 'false', 'normalize': 'true', 'ascii': 'true'}; CREATE CUSTOM INDEX registration_idx ON cycling.cyclist_semi_pro (registration) USING 'StorageAttachedIndex';
-
end::dse51[]