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

0 vote278 views1 answer
Add user mysql wordpress
SQL
0 vote161 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
9 votes190 views6 answers
Check constraint in sql
SQL
0 vote167 views1 answer
What are the aggregate function in sql
SQL
0 vote176 views2 answers
How to count codition
SQL
0 vote195 views1 answer
Mysql date without time
SQL
1 vote141 views2 answers
Delete auto increment mysql
SQL
5 votes196 views1 answer
Oracle nls parameters
SQL
0 vote199 views1 answer
.sql File Run in PSQL
SQL
0 vote182 views1 answer
Php get closest location by latitude longitude
SQL