Sql multi column index performance

CREATE INDEX idx_actor_name ON ACTOR (LAST_NAME, FIRST_NAME);

SELECT * FROM CUSTOMER c WHERE ADDRESS_ID = 10
AND exists(
    SELECT 1 FROM ACTOR a
    WHERE c.FIRST_NAME = a.FIRST_NAME
      AND c.LAST_NAME = a.LAST_NAME
);

Similar codes

45 votes245 views5 answers
Grant all privileges mysql
SQL
0 vote160 views1 answer
Odd record sql query
SQL
0 vote149 views2 answers
Mysql password error create datbase
SQL
0 vote184 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
1 vote153 views1 answer
Show table columns
SQL
0 vote173 views1 answer
Select lowest values sql
SQL
0 vote158 views1 answer
Null column as zero in mysql
SQL
0 vote180 views1 answer
Pgadmin check database
SQL
1 vote205 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote164 views4 answers
Forenkey code alchemy sql
SQL