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 votes141 views3 answers
Sql drop database if exists
SQL
0 vote156 views1 answer
Stored function in sql
SQL
1 vote154 views4 answers
Fatal database postgres does not exist
SQL
0 vote139 views1 answer
The local psql command could not be located
SQL
2 votes203 views2 answers
Postgres drop column if exists
SQL
5 votes163 views1 answer
Oracle asynchronous update
SQL
12 votes150 views4 answers
How to take database dump in postgresql
SQL
0 vote143 views2 answers
Find Overlapping sql
SQL
0 vote158 views2 answers
Oracle sql for each row
SQL
0 vote137 views1 answer
Difference between cross apply and inner join
SQL