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 vote170 views1 answer
Executescalar in sql server
SQL
-1 vote221 views5 answers
Left join sql
SQL
3 votes139 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote138 views1 answer
SQL Server format datetime
SQL
2 votes148 views2 answers
Run mysql command from bash
SQL
0 vote144 views2 answers
Check mysql timezone
SQL
0 vote158 views1 answer
Import Data in MySQL without using any other software
SQL
1 vote142 views1 answer
Duplicating a MySQL table with all the data Command
SQL
1 vote153 views1 answer
Mysql f# examples
SQL
0 vote296 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL