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

4 votes251 views1 answer
Sql select limit range
SQL
0 vote230 views1 answer
Set root password mysql xampp
SQL
0 vote221 views1 answer
Mariadb datetime change to microseconds
SQL
4 votes219 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
3 votes216 views2 answers
Oracle grants
SQL
0 vote242 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote257 views1 answer
Mysql create index lost connection
SQL
0 vote224 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
1 vote247 views1 answer
Mysql find most common value
SQL
28 votes172 views6 answers
Distinct sql
SQL