Sql multiple column 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 vote299 views1 answer
Postgres left join
SQL
1 vote265 views1 answer
Adding a default constraint to an existing column in sql
SQL
1 vote290 views3 answers
Sql procedure
SQL
1 vote269 views2 answers
Change table name phpmyadmin
SQL
0 vote283 views1 answer
Java mysql swing example
SQL
0 vote251 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote247 views1 answer
Sql requete number pair
SQL
0 vote272 views1 answer
Get the previous column of a table in mysql
SQL
0 vote267 views1 answer
Use where instead of join
SQL
1 vote272 views1 answer
Mysql return text after a final full stop
SQL