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 vote108 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
3 votes110 views1 answer
V$session not found in oracle
SQL
0 vote104 views1 answer
Mysql Error Code: 1005
SQL
3 votes103 views1 answer
Oracle list user grants
SQL
6 votes107 views2 answers
Psql load dump
SQL
54 votes268 views6 answers
Sql rename column
SQL
0 vote110 views1 answer
Oracle synonym procedure
SQL
1 vote112 views1 answer
Right outer vs left outer join
SQL
0 vote95 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote60 views1 answer
How to connect sql server using ip address in c#
SQL