Check SAI existence
Prerequisites
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';
CREATE CUSTOM INDEX rank_idx ON cycling.rank_by_year_and_name (rank) USING 'StorageAttachedIndex';If you prefer 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';
CREATE CUSTOM INDEX rank_idx ON cycling.rank_by_year_and_name (rank) USING 'StorageAttachedIndex';end::dse51[]
