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 vote124 views1 answer
Postgres cast as currency format
SQL
0 vote124 views1 answer
Restart sql server command line linux
SQL
0 vote132 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
7 votes118 views3 answers
Restore postgres database from sql file
SQL
0 vote111 views1 answer
Sql offfset
SQL
0 vote114 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote108 views1 answer
MySQL AND Operator
SQL
1 vote111 views1 answer
Oracle add proxy
SQL
56 votes204 views5 answers
Psql create user
SQL
0 vote125 views1 answer
Const pool = mysql.createpool()
SQL