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

2 votes318 views1 answer
How to delete view in sql
SQL
3 votes326 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote307 views1 answer
Oracle sql generate list of days
SQL
16 votes318 views4 answers
Sort by sql
SQL
0 vote342 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote336 views1 answer
Shows all databases created by user in ms sql
SQL
1 vote303 views6 answers
In sql
SQL
0 vote312 views1 answer
Postgress append string in select
SQL
0 vote316 views1 answer
Alter owner in PostgreSQL
SQL
11 votes287 views1 answer
Reset identity sql server
SQL