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 vote107 views2 answers
Avg() sql
SQL
0 vote139 views1 answer
Power bi union columns
SQL
1 vote141 views1 answer
Mysql decimal allow negative values?
SQL
0 vote148 views1 answer
Make parameters nullable in sql server
SQL
0 vote145 views1 answer
Oracle allow space to user
SQL
3 votes164 views2 answers
How to modify rows in SQL Server
SQL
0 vote138 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote124 views1 answer
Oracle 11g forget password
SQL
0 vote133 views1 answer
Sql datediff db2
SQL
6 votes128 views4 answers
Delete table sqlite
SQL