Sql double 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 vote150 views1 answer
Sqlite trim
SQL
0 vote128 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote118 views1 answer
How to find unique key in sql
SQL
1 vote123 views1 answer
Mysql check string don't have number
SQL
2 votes143 views1 answer
Guid to string sql
SQL
0 vote130 views1 answer
Sql select column names starting with
SQL
3 votes132 views2 answers
Mysql HAVING
SQL
3 votes128 views3 answers
Create table in microsoft sql server
SQL
1 vote160 views2 answers
Laravel jwt generate token
SQL
3 votes155 views3 answers
Start postgresql ubuntu
SQL