Examine these statements which execute successfully:Which two changes will improve this query performance?

CREATE INDEX 1X7 ON users (user_name) USING HASH;

CREATE INDEX 1X4 ON Locations (site_id, loc_shared);

CREATE INDEX IX1 ON locations (loc_shareci) ;

CREATE INDEX 1X6 ON users (user_name);

CREATE INDEX 1X3 ON locations

CREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH

CREATE INDEX 1X5 ON users (loc_id);