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 vote216 views1 answer
Sql right characters
SQL
2 votes218 views1 answer
Mysql list users on ubuntu
SQL
0 vote248 views1 answer
Alter table engine mysql
SQL
0 vote239 views1 answer
Sqlalchemy query join many to many
SQL
0 vote224 views1 answer
Get foreign table names mysql
SQL
5 votes226 views4 answers
Sql check
SQL
2 votes250 views2 answers
Mysql write into table
SQL
0 vote221 views1 answer
Double in sql server example
SQL
0 vote229 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
1 vote248 views1 answer
Vagrant mysql downgrade version
SQL