Sql multi column index performance

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

2 votes372 views3 answers
Sql server: how to concatenate column data using comma
SQL
11 votes337 views1 answer
Ddl materialized view
SQL
0 vote351 views1 answer
Exec procedure oracle
SQL
0 vote359 views1 answer
Creating a simple notify in postgresql
SQL
6 votes364 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
10 votes390 views2 answers
Mysql remove only_full_group_by permanently
SQL
0 vote361 views2 answers
Timing sql queries
SQL
1 vote343 views1 answer
How to get alternate records from a table in sql
SQL
3 votes358 views2 answers
Oracle grants
SQL
1 vote341 views1 answer
Mysql Case sum
SQL