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 vote260 views2 answers
Getting customers with no orders sql
SQL
0 vote269 views1 answer
Createdb with postgresql on ubuntu
SQL
3 votes224 views1 answer
Postgresql where current year
SQL
0 vote283 views1 answer
Check command
SQL
0 vote286 views1 answer
Oracle decode
SQL
0 vote274 views1 answer
Day of the week sqlite
SQL
-1 vote272 views3 answers
SQL MM/dd/yyyy format
SQL
16 votes305 views3 answers
T-SQL Add Column
SQL
2 votes268 views4 answers
Sql query interview questions
SQL
0 vote279 views1 answer
Insert ip address in mysql
SQL