Sql multiple column 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

1 vote239 views1 answer
Sql server today minus n
SQL
1 vote224 views1 answer
Mysql get latest duplicate rows
SQL
16 votes250 views2 answers
Mysql date between two dates
SQL
3 votes293 views1 answer
Mysql cli connect with password
SQL
0 vote235 views1 answer
How to install sql in anaconda
SQL
0 vote246 views1 answer
Sqlite insert or update
SQL
10 votes281 views4 answers
Join multiple tables in sql
SQL
0 vote234 views1 answer
Oracle current timestamp
SQL
8 votes242 views1 answer
Sql limit results returned
SQL
0 vote218 views1 answer
10000000000000000000 am to meters
SQL