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 vote362 views1 answer
Sql getdate minus 1 day without time
SQL
4 votes400 views6 answers
Select sql
SQL
15 votes333 views2 answers
How to know the username of postgresql
SQL
0 vote400 views1 answer
Mysql get first 2 characters of string
SQL
5 votes350 views1 answer
How to check nls format in oracle
SQL
1 vote367 views1 answer
Name of today sql
SQL
0 vote351 views1 answer
Replace string in whole database mysql stackoverflow
SQL
5 votes329 views2 answers
Mysql where in array
SQL
0 vote346 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
1 vote369 views1 answer
Print year of a date sql
SQL