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 vote264 views2 answers
Postgres select from last 3 months
SQL
0 vote144 views1 answer
Where date in datetime mysql
SQL
0 vote196 views1 answer
Sqlite display headers on columns
SQL
0 vote130 views1 answer
Test connection to sql server
SQL
0 vote133 views1 answer
Mysql remove tabs from string
SQL
0 vote146 views1 answer
Mysql coonect sample code
SQL
0 vote133 views1 answer
Find number of entries sql
SQL
0 vote137 views1 answer
Add timestamp column to existing table ms sql server
SQL
3 votes132 views2 answers
Sql end of month
SQL
0 vote141 views1 answer
Not equal to blank in mysql
SQL