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 vote338 views1 answer
SQL loop with cursor
SQL
6 votes323 views1 answer
Oracle rank() over (partition)
SQL
38 votes435 views6 answers
Ubuntu install mysql client
SQL
2 votes353 views1 answer
Mysql application.properties spring boot
SQL
0 vote341 views2 answers
Jsonb
SQL
0 vote323 views1 answer
Mysql local password denied
SQL
0 vote313 views1 answer
Metada in sql
SQL
3 votes344 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote352 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote349 views1 answer
Sqlite commands
SQL