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 vote206 views1 answer
Multiple tricky query in sql server
SQL
0 vote209 views3 answers
Magento 2 order delete from db
SQL
0 vote201 views1 answer
How to create a new db from dumb file mysql
SQL
16 votes206 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote239 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote219 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote206 views2 answers
Close external port 3306 with iptables
SQL
2 votes189 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote210 views1 answer
Oracle last connexion
SQL
2 votes197 views1 answer
Anonymous block plsql
SQL