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

0 vote131 views1 answer
Finding leap year in sql
SQL
0 vote127 views1 answer
Mysql into outfile with headers
SQL
0 vote106 views2 answers
Sqlite unix timestamp
SQL
0 vote129 views1 answer
ORACLE PARSE STRING
SQL
1 vote114 views1 answer
Mysql copy table1 to table2
SQL
8 votes93 views3 answers
Duplicate entry
SQL
1 vote117 views2 answers
Sql server concat string and int
SQL
9 votes101 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote102 views1 answer
How to change null display in psql
SQL
0 vote115 views1 answer
Get last updated row sql server
SQL