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 vote194 views1 answer
Exclude last comma separated string mysql
SQL
0 vote195 views1 answer
Add alternate add column sql
SQL
8 votes190 views2 answers
Mysql get first x characters
SQL
1 vote212 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
1 vote193 views1 answer
Oracle difference between two dates in years
SQL
0 vote158 views1 answer
Copy data from cell to cell mysql
SQL
0 vote221 views1 answer
Sqlcmd no headers
SQL
1 vote286 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote217 views1 answer
Sql injection payload list github
SQL
8 votes191 views4 answers
Mysql update one table from another table multiple columns
SQL