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

0 vote130 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
1 vote107 views1 answer
Select from one table where not on the other
SQL
0 vote113 views1 answer
Mariadb maximum left join
SQL
0 vote115 views1 answer
Mysql DDL
SQL
0 vote117 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote131 views1 answer
Update sqlite
SQL
0 vote124 views1 answer
Sqlite commands
SQL
0 vote108 views1 answer
Edit a field mysql terminal
SQL
0 vote164 views1 answer
Ora 00001 error catch plsql
SQL
0 vote122 views1 answer
SQL FROM-Klausel
SQL