Check SAI existence

Verify that a SAI index exists using the DESCRIBE INDEX command:

DESCRIBE INDEX cycling.rank_idx;

Results

CREATE CUSTOM INDEX rank_idx ON cycling.rank_by_year_and_name (rank) USING 'StorageAttachedIndex';

To verify the index and table schema in a single command, use the DESCRIBE TABLE command:

DESCRIBE TABLE cycling.rank_by_year_and_name;

Results

CREATE CUSTOM INDEX rank_idx ON cycling.rank_by_year_and_name (rank) USING 'StorageAttachedIndex';

Give Feedback