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 vote148 views1 answer
Mysql check datetime equals date
SQL
7 votes145 views1 answer
Query postgres delete duplicates
SQL
2 votes137 views1 answer
How to delete view in sql
SQL
0 vote129 views1 answer
Partitioning in oracle-base
SQL
1 vote139 views1 answer
Update foreign key value in mysql
SQL
1 vote139 views1 answer
Postgresql round double precision
SQL
0 vote148 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote145 views1 answer
Get the previous column of a table in mysql
SQL
0 vote143 views1 answer
Storing RGBA in mysql db
SQL
1 vote144 views2 answers
Sql left characters
SQL