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 vote318 views1 answer
Python list from sql
SQL
1 vote289 views4 answers
Between vs in sql
SQL
0 vote316 views3 answers
Fetlife
SQL
5 votes299 views1 answer
Oracle generate list of dates in between a date range
SQL
2 votes321 views4 answers
Check timezone of mysql database
SQL
0 vote316 views1 answer
Consulta alias con inner join
SQL
0 vote321 views1 answer
Shrink database file in sql server
SQL
0 vote302 views1 answer
How to combine rows in sql server procedure
SQL
1 vote308 views1 answer
Sql restore backup query
SQL
0 vote307 views1 answer
Mysql min value row
SQL