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

3 votes271 views1 answer
Select sequence oracle
SQL
1 vote256 views1 answer
Sql injection
SQL
0 vote305 views1 answer
Yesql
SQL
0 vote297 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote269 views1 answer
Merge clause with inner join
SQL
0 vote315 views1 answer
Insert query return id mysql
SQL
1 vote288 views4 answers
Get week day from date in sql
SQL
0 vote293 views1 answer
.sql File Run in PSQL
SQL
0 vote283 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote246 views2 answers
Mysql SELECT
SQL