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 vote315 views1 answer
Mysql show create db
SQL
1 vote337 views1 answer
Where date = max(date) in sql
SQL
0 vote325 views1 answer
Java check if something is in mysql table
SQL
0 vote311 views1 answer
Sql get table last modified time
SQL
-1 vote317 views1 answer
Sql add column bit
SQL
2 votes324 views1 answer
Postgresql left join distinct on
SQL
3 votes304 views1 answer
Sql select all
SQL
0 vote344 views1 answer
Postgres regex word boundary
SQL
1 vote312 views10 answers
Stack overflow
SQL
0 vote350 views1 answer
Mysql remove bad character from all fields
SQL