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 vote177 views1 answer
Change filed order in mysql
SQL
0 vote169 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote172 views1 answer
Oracle current timestamp insert statement
SQL
0 vote182 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote189 views3 answers
Constraint sql
SQL
0 vote188 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote185 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote166 views1 answer
Resulting Query
SQL
4 votes159 views2 answers
How to delete row in sql
SQL
0 vote225 views1 answer
Delete from IN subquery
SQL