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

8 votes374 views2 answers
Between operator
SQL
5 votes330 views4 answers
Sql check
SQL
1 vote340 views3 answers
Update from select sqlite
SQL
31 votes331 views1 answer
Postgresql add column with constraint
SQL
0 vote367 views1 answer
Running mysql from bash sc
SQL
0 vote336 views1 answer
Sql contains vs like
SQL
0 vote365 views1 answer
Java sql insert return id
SQL
0 vote347 views1 answer
Remove binlog mysql
SQL
-1 vote362 views1 answer
Minus vs except in sql
SQL
0 vote339 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL