Sql double index

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

1 vote320 views1 answer
Print all records of table in mysql
SQL
0 vote299 views1 answer
Select from column mysql
SQL
11 votes320 views3 answers
Python sqlite3 create table if not exists
SQL
3 votes276 views1 answer
Oracle nextval
SQL
0 vote330 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote272 views1 answer
Mysql select row with min date
SQL
0 vote299 views1 answer
Mysqlcli how to load external sql file
SQL
2 votes307 views3 answers
Mysql pass command from command line
SQL
4 votes298 views5 answers
Primary key
SQL
0 vote304 views1 answer
Mysql failed to login as root@localhost
SQL