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

16 votes197 views3 answers
Update table from another table
SQL
0 vote192 views1 answer
What does leave do in mysql
SQL
-1 vote194 views1 answer
Can pandas fetch data from sql
SQL
0 vote198 views1 answer
Get rows from 1 table with other table empty mysql
SQL
2 votes184 views1 answer
Ssh mysql port forwarding
SQL
1 vote187 views1 answer
Postgres convert date to string
SQL
0 vote192 views1 answer
On delete set default
SQL
4 votes134 views1 answer
Oracle sleep
SQL
0 vote194 views1 answer
Sql last time database was accessed
SQL
-1 vote179 views1 answer
How to switch user in mysql
SQL