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 vote150 views1 answer
CONVERT time string into 12 hours in sql
SQL
-2 votes116 views2 answers
Union vs union all in sql
SQL
0 vote149 views1 answer
Sql select without column name
SQL
0 vote99 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
10 votes116 views4 answers
Join multiple tables in sql
SQL
0 vote100 views1 answer
Mysql remove tabs from string
SQL
2 votes115 views4 answers
2nd highest salary in mysql
SQL
-1 vote112 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote100 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote126 views1 answer
C# select Mysql
SQL