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 vote143 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote105 views1 answer
Sql count how many times a value appears
SQL
0 vote176 views1 answer
Sqlite trim
SQL
1 vote156 views1 answer
Update from select oracle
SQL
0 vote157 views1 answer
Mysql concatenate select results
SQL
0 vote140 views1 answer
Do postgresql
SQL
1 vote126 views4 answers
Sql now
SQL
8 votes161 views2 answers
Grant all privileges database postgres to user
SQL
0 vote178 views1 answer
Drop domain postgresql
SQL
2 votes149 views1 answer
Mysql application.properties spring boot
SQL