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

5 votes230 views1 answer
Mysql created at yesterdau
SQL
62 votes473 views8 answers
Mysql add column
SQL
0 vote192 views1 answer
Mysql filter based on datediff
SQL
24 votes186 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote380 views1 answer
Why do we need data structure in sql
SQL
0 vote183 views1 answer
Mysql url
SQL
23 votes200 views6 answers
Create table sql server
SQL
0 vote175 views1 answer
Online sql testing tool
SQL
0 vote180 views1 answer
Connexion mysql
SQL
0 vote183 views1 answer
Set a default value for a column in sqlite
SQL