Sql multiple column 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

3 votes202 views1 answer
Fk in insert mysql
SQL
2 votes212 views4 answers
2nd highest salary in mysql
SQL
0 vote202 views1 answer
Select sql in descending order
SQL
0 vote219 views1 answer
How to access to mysql without root
SQL
1 vote262 views1 answer
Continue in sql
SQL
1 vote528 views1 answer
Mysql event last execution
SQL
0 vote204 views1 answer
Describe in sqlite3
SQL
1 vote187 views5 answers
Spring boot sql logging
SQL
0 vote201 views1 answer
How to query all tables mysql at the same time
SQL
0 vote220 views1 answer
How to enable mysql 5.7 root user password on linux
SQL