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 vote159 views2 answers
Delete the last item in a table sql
SQL
40 votes188 views6 answers
Update table mysql
SQL
0 vote189 views1 answer
Mysql return column names when table is empty
SQL
0 vote240 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote197 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote185 views1 answer
Postgresql regular expression special characters
SQL
17 votes199 views3 answers
Cast in sql server
SQL
0 vote223 views1 answer
Show specific events on mysql
SQL
1 vote189 views1 answer
Postgresql datetrunc too slow
SQL
51 votes312 views6 answers
Opera gx
SQL