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

23 votes250 views6 answers
How to create table in sql
SQL
6 votes254 views2 answers
Psql load dump
SQL
2 votes258 views1 answer
Q operator in oracle
SQL
0 vote230 views1 answer
Oracle exchange subpartition
SQL
0 vote239 views2 answers
Wordpress change url in database
SQL
0 vote271 views1 answer
Virtuoso sql query tutorial
SQL
0 vote248 views1 answer
Sqlcl format
SQL
0 vote256 views1 answer
Mysql command line top 10
SQL
0 vote242 views1 answer
Tsql pad left
SQL
0 vote211 views1 answer
Como leer datos de mysql esp32
SQL