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 vote326 views2 answers
Laravel jwt generate token
SQL
0 vote284 views1 answer
Mysql get only the field names in a table
SQL
6 votes266 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote290 views1 answer
Selecting duplicates
SQL
-1 vote239 views1 answer
Oracle db list usernames
SQL
0 vote279 views1 answer
Fast sql column count
SQL
0 vote319 views1 answer
Sparql list all graphs
SQL
123 votes465 views5 answers
Sql where contains
SQL
2 votes271 views1 answer
Oracle sql concatenate results into string
SQL
0 vote261 views1 answer
Mysql select all where count more than"
SQL