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 vote463 views1 answer
Compare strings lexicographically in sql
SQL
16 votes429 views1 answer
Sqlserver add column to table
SQL
7 votes374 views3 answers
Select latest entry in sql table
SQL
1 vote411 views3 answers
Date_add mysql
SQL
0 vote368 views1 answer
Database xml sql
SQL
1 vote371 views1 answer
Jooq convert using gbk
SQL
0 vote418 views1 answer
Mysql streaming example
SQL
16 votes352 views4 answers
Mysql import from sql file
SQL
0 vote355 views1 answer
How to print out column name differently in mysql
SQL
0 vote372 views1 answer
Date on SQL
SQL