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

22 votes321 views4 answers
Mysql date format
SQL
0 vote201 views1 answer
Remove transient options sql wordpress
SQL
19 votes204 views6 answers
Mysql if null
SQL
7 votes196 views3 answers
Sql set
SQL
0 vote192 views1 answer
Pl/ sql change currency
SQL
0 vote270 views1 answer
Offset in postgresql example
SQL
0 vote216 views2 answers
Call to undefined function mysql_query()
SQL
2 votes134 views1 answer
Sql select in list
SQL
2 votes232 views1 answer
Create delete procedure mysql
SQL
0 vote198 views1 answer
What does leave do in mysql
SQL