Sql double 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 vote184 views1 answer
Power query datetime to date
SQL
0 vote186 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote210 views3 answers
Condition in count sql
SQL
1 vote249 views1 answer
How to show index type in postgresql
SQL
1 vote204 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote191 views1 answer
Insert into using contant values and source table columns with sql
SQL
244 votes482 views14 answers
Sql n insert
SQL
0 vote187 views1 answer
Mysql update privileges
SQL
0 vote191 views1 answer
Create or replace view postgress
SQL
0 vote228 views1 answer
Grouping by email domain mysql
SQL