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

1 vote242 views1 answer
SQL query to get all table records count from a database
SQL
-1 vote269 views1 answer
Ms sql select datetime as date
SQL
0 vote237 views1 answer
Mysql where in maintain order
SQL
3 votes232 views2 answers
Postgresql select all column names
SQL
0 vote236 views1 answer
Postgresql on conflict pair
SQL
7 votes257 views2 answers
Sql remove duplicates based on column
SQL
17 votes269 views1 answer
Selecting name that contain certain word in sql
SQL
7 votes229 views3 answers
Foreign key oracle
SQL
1 vote242 views2 answers
Maximum number of tables in mysql
SQL
0 vote190 views1 answer
Check sql query executed wp
SQL