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

1 vote308 views2 answers
Mysql does sentance contain word
SQL
0 vote321 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote319 views1 answer
How to get data between a last week in mysql
SQL
0 vote311 views1 answer
Sql server update top n records
SQL
1 vote333 views1 answer
Cross schema query oracle 2 users
SQL
0 vote367 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote352 views1 answer
What is SQL data store?
SQL
1 vote366 views1 answer
Mysql find most common value
SQL
7 votes346 views2 answers
Where keyword sql
SQL
0 vote313 views1 answer
Sql last 7 days
SQL