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.

Drop the SAI 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';

Alter SAI index

Was this helpful?

Give Feedback