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

4 votes197 views1 answer
Sql any
SQL
4 votes205 views1 answer
Phone number sql
SQL
0 vote206 views1 answer
Update one column from another column in same table
SQL
0 vote220 views2 answers
Mysql row_number() example
SQL
0 vote209 views1 answer
Mysql database hyphen
SQL
1 vote197 views10 answers
Stack overflow
SQL
0 vote212 views1 answer
Oracle right characters
SQL
11 votes340 views2 answers
Import mysql dump command line windows
SQL
3 votes196 views1 answer
Oracle user quota unlimited
SQL
23 votes281 views2 answers
Query to delete a database in mysql
SQL