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 vote205 views1 answer
FIND most frequent word in sql server
SQL
3 votes223 views2 answers
Mysql import gz
SQL
2 votes288 views2 answers
Null column to 0 in mysql
SQL
1 vote220 views1 answer
Denied
SQL
5 votes223 views1 answer
Oracle list functions
SQL
0 vote220 views1 answer
How to inner join 4 tables in sql
SQL
8 votes249 views1 answer
Oracle add datafile to tablespace
SQL
0 vote188 views1 answer
Online sql testing tool
SQL
0 vote198 views2 answers
Add colum in sql
SQL
3 votes209 views1 answer
Show index table
SQL