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 vote322 views1 answer
Heavy table in mysql
SQL
0 vote345 views1 answer
Difference between 2 query results sql server
SQL
0 vote335 views1 answer
Sql developer sql worksheet not showing
SQL
-1 vote337 views1 answer
Sql oracle take only last results
SQL
0 vote324 views1 answer
Sql select all tables from database change url
SQL
5 votes366 views1 answer
Sql table columns
SQL
1 vote371 views1 answer
T-sql find object by name
SQL
8 votes341 views2 answers
Python simple connect to mysql
SQL
0 vote380 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote339 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL