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

10 votes194 views1 answer
All_dependencies
SQL
8 votes200 views1 answer
Mysql restore database
SQL
1 vote176 views1 answer
SQLite order random
SQL
1 vote193 views1 answer
Alter constraint in sql
SQL
0 vote189 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote134 views2 answers
Denormalization in sql
SQL
0 vote174 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote182 views1 answer
C# add a textbox in mysql select
SQL
2 votes180 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
4 votes189 views2 answers
Sql offset
SQL