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 vote326 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote318 views1 answer
Resulting Query
SQL
0 vote343 views1 answer
Value of sold product using having and group by in sql
SQL
24 votes322 views4 answers
Mssql get all table names
SQL
1 vote353 views1 answer
Is sql fast
SQL
0 vote334 views1 answer
T-SQL - Where Used List (Table/View)
SQL
2 votes348 views3 answers
Sql interview query questions
SQL
18 votes330 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote393 views1 answer
Eliminate zero from integer mysql
SQL
1 vote346 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL