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

20 votes283 views5 answers
Reset auto increment mysql
SQL
0 vote290 views1 answer
Incorrect datetime value sql table error 1292
SQL
0 vote296 views1 answer
Sql server select record with max id
SQL
2 votes303 views1 answer
Sql server current date minus 5 years
SQL
0 vote286 views1 answer
Get yesterday date ISO in psql
SQL
10 votes310 views2 answers
Mysql alter add foreign key
SQL
103 votes476 views2 answers
Sql server LIKE '%%'
SQL
0 vote295 views2 answers
How covert into int in maria db
SQL
0 vote278 views1 answer
Select from 3 tables one is empty
SQL
0 vote267 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL