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 vote353 views1 answer
Mariadb number format
SQL
1 vote355 views1 answer
Mysql best tutorial for beginners
SQL
0 vote364 views1 answer
Remove binlog mysql
SQL
150 votes643 views10 answers
Grepper
SQL
0 vote346 views1 answer
Xampp mysql version
SQL
13 votes338 views3 answers
Sql online code
SQL
0 vote337 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote373 views1 answer
Mariadb cast null to 0
SQL
0 vote367 views1 answer
Using distinct and count together in sql
SQL
4 votes332 views2 answers
Select todays data postgres query
SQL