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

10 votes270 views4 answers
Sql server pagination
SQL
0 vote178 views1 answer
Codeigniter dbforge add index
SQL
1 vote204 views3 answers
Sql procedure
SQL
1 vote140 views1 answer
Enable mysql slow query log
SQL
1 vote202 views2 answers
Mysql does sentance contain word
SQL
0 vote202 views1 answer
Insert value in identity
SQL
0 vote179 views1 answer
How to add session data into mysql database from button
SQL
9 votes172 views2 answers
Cmd to rename a collumn name in sql
SQL
3 votes202 views1 answer
Oracle user quota on tablespace
SQL
1 vote223 views1 answer
Mysql tables max count
SQL