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

0 vote319 views1 answer
Mysql docker image for macbook m1
SQL
1 vote339 views1 answer
Raise application error in oracle
SQL
0 vote364 views3 answers
Java hide mysql login credentials
SQL
0 vote329 views2 answers
Sql join on wildcard
SQL
0 vote336 views1 answer
Difference between db.query and db.execute
SQL
1 vote349 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
1 vote357 views1 answer
Set id count mysql
SQL
-1 vote316 views1 answer
Sql getdate date only
SQL
0 vote306 views1 answer
Wordpress sql find and replace
SQL
0 vote328 views1 answer
Mysql dump everythign
SQL