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 vote119 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote118 views1 answer
Cannot pip install mysqlclient
SQL
0 vote110 views1 answer
Oracle free up space in tablespace
SQL
0 vote79 views1 answer
Ms sql unique
SQL
7 votes124 views2 answers
MySQL IF without else
SQL
5 votes190 views1 answer
Oracle asynchronous procedure
SQL
1 vote123 views1 answer
Sql week commencing date
SQL
0 vote146 views1 answer
Isnull in sqlite
SQL
0 vote111 views1 answer
Oracle SQL join three tables and group by column
SQL
1 vote138 views3 answers
Sql procedure
SQL