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 vote149 views1 answer
How much table store postgres
SQL
14 votes1.1K views1 answer
Sql value of string
SQL
0 vote140 views3 answers
Average salary in sql
SQL
0 vote152 views1 answer
Postgresql copy backup table
SQL
0 vote215 views1 answer
Sql select max value for each group
SQL
-3 votes143 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote182 views3 answers
CONTACT FORM SQL
SQL
0 vote154 views1 answer
Sql get guid
SQL
10 votes158 views3 answers
Sql select between two dates
SQL
1 vote161 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL