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 vote325 views1 answer
Epoch time converter in snowflake
SQL
13 votes327 views3 answers
Change data type postgresql
SQL
0 vote310 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
-1 vote284 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
8 votes266 views1 answer
Similarities between ddl and dml
SQL
0 vote331 views1 answer
Postgre query date
SQL
4 votes310 views4 answers
Pl sql output
SQL
14 votes328 views4 answers
Import database through command line
SQL
2 votes318 views4 answers
Mysql get all tables row count
SQL
3 votes355 views2 answers
Wp do sql query from function
SQL