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 vote197 views1 answer
Psql check table fields
SQL
5 votes169 views1 answer
Sort order on two columns sql
SQL
5 votes164 views1 answer
Oracle ORA-00054 origin
SQL
2 votes167 views1 answer
Select from array in psql
SQL
8 votes194 views6 answers
Sql insert
SQL
0 vote183 views1 answer
Sql tablo sp
SQL
0 vote166 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote174 views1 answer
Insert into select with group by
SQL
0 vote167 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote165 views1 answer
Real world example of nosql
SQL