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

0 vote354 views2 answers
How to set global time_zone in mysql
SQL
9 votes331 views4 answers
How to remove duplicate in sql
SQL
2 votes345 views3 answers
Oracle show column of table
SQL
0 vote334 views1 answer
Porcentaje sql
SQL
0 vote302 views1 answer
Query for maximum salary
SQL
0 vote357 views1 answer
Multiple left join mysql
SQL
0 vote427 views1 answer
Intellij mysql set timezone
SQL
4 votes344 views1 answer
Create db table
SQL
0 vote373 views1 answer
Will graphql replace sql
SQL
0 vote316 views1 answer
Sqlite3 now
SQL