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 vote308 views2 answers
Find lowest number in sql
SQL
1 vote364 views1 answer
Drop colum oracle 18c
SQL
0 vote324 views1 answer
Mysql select smaller of two values
SQL
1 vote311 views2 answers
Sql select only first occurrence
SQL
0 vote351 views1 answer
How to pass list as parameter in SQL query
SQL
5 votes301 views2 answers
Update all rows mysql
SQL
0 vote336 views1 answer
What is initial catalog in sql connection string
SQL
7 votes320 views2 answers
Execute mysql file
SQL
0 vote423 views1 answer
Php insert null mysql
SQL
0 vote303 views1 answer
Mod function example
SQL