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

0 vote240 views2 answers
Mysql cast to varchar
SQL
24 votes217 views4 answers
Delete db postgres
SQL
2 votes202 views1 answer
Oracle trace file
SQL
1 vote189 views1 answer
MySQL AND Operator
SQL
0 vote197 views1 answer
Soql more than today
SQL
0 vote222 views1 answer
Count database access django
SQL
1 vote197 views1 answer
Postgres check blocking
SQL
1 vote204 views1 answer
Mysql tables max count
SQL
0 vote205 views1 answer
Sql delete caracter list
SQL
1 vote218 views1 answer
Oracle sequence last_number
SQL