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

5 votes170 views2 answers
Copy data from one database to another
SQL
0 vote172 views1 answer
Django mysqlclient connection string
SQL
0 vote174 views1 answer
Mariadb mysql root access denied
SQL
23 votes170 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
9 votes177 views4 answers
How to create new user and database postgresql in ubuntu
SQL
3 votes157 views1 answer
MySQL DELETE JOIN
SQL
-1 vote194 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote190 views2 answers
How to see table associated with a schema in sql
SQL
0 vote172 views1 answer
Mysql query to add hours to column in table
SQL
2 votes213 views2 answers
Mysql write into table
SQL