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

25 votes114 views4 answers
Metadata
SQL
1 vote268 views2 answers
Coderbyte sql solutions
SQL
2 votes96 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote100 views1 answer
Sqlite higher or equal
SQL
10 votes102 views2 answers
Sql rtrim
SQL
0 vote106 views1 answer
Copy data from one postgres container to another
SQL
0 vote102 views1 answer
How to select only id where is not in column mysql
SQL
1 vote97 views3 answers
How to truncate table with foreign key constraint
SQL
1 vote103 views1 answer
SQLSTATE[HY000] [2002]
SQL
1 vote94 views1 answer
Oracle check table space
SQL