Sql multiple column index

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 votes266 views3 answers
Mysql extract month from date
SQL
20 votes275 views3 answers
Update values in select statement sql
SQL
9 votes275 views1 answer
Alter table column change data type to text mysql
SQL
15 votes261 views4 answers
How to get all tables in sql
SQL
1 vote218 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
1 vote272 views1 answer
Mysql breakline on string
SQL
1 vote273 views1 answer
Mysql check string don't have number
SQL
2 votes289 views3 answers
How to check current user in mySQL
SQL
10 votes251 views3 answers
Insert into auto increment mysql
SQL
0 vote291 views1 answer
Mysql dump with table query
SQL