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

1 vote220 views1 answer
Sql server epoch to datetime
SQL
1 vote220 views1 answer
Mysql list bigger table
SQL
1 vote224 views1 answer
Sql server insert into temp table
SQL
1 vote202 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote246 views1 answer
Alter domain sql
SQL
47 votes232 views6 answers
Add column mysql
SQL
0 vote227 views1 answer
Import sql in postgresql
SQL
11 votes234 views2 answers
You are using safe update mode
SQL
1 vote220 views1 answer
Load mysql dumb
SQL
0 vote213 views1 answer
Sql remove non numeric characters
SQL