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 vote136 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
-2 votes142 views1 answer
Remove root password mysql
SQL
1 vote137 views1 answer
Search for replace in mysql
SQL
2 votes125 views1 answer
When matched in sql server
SQL
3 votes136 views1 answer
Oracle drop user
SQL
0 vote125 views1 answer
Docker export psql sql
SQL
28 votes130 views4 answers
Delete database mysql
SQL
0 vote136 views1 answer
Closure in sql
SQL
0 vote143 views1 answer
What is top n result in sql
SQL
7 votes129 views1 answer
Mysql remote connection command line
SQL