DWP301c_-_FE_-_COURSERA_-_FA_2023_1188.webp

27. Alex is working on a high-performance database project and needs to improve query performance by creating an index on a specific column. Which SQL statement should he use to create an index?
1 point
CREATE INDEX idx_name ON table_name(column_name)
ALTER TABLE table_name ADD INDEX (column_name)
ADD INDEX idx_name ON table_name(column_name)
INDEX CREATE idx_name ON table_name(column_name)
FUO