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 vote128 views1 answer
Dnsmasq.conf location macos
SQL
0 vote146 views1 answer
Mysql create pool
SQL
0 vote152 views1 answer
Mysql update from select on same table
SQL
5 votes154 views2 answers
Create function postgresql
SQL
0 vote142 views1 answer
Select password from user mysql
SQL
0 vote158 views1 answer
Count in sql and diff
SQL
0 vote179 views1 answer
Postgres docs /copy metacomand
SQL
51 votes246 views6 answers
Change column name sql
SQL
0 vote143 views1 answer
Pip install mysqlclient error
SQL
7 votes243 views2 answers
Sql empty table
SQL