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 vote191 views1 answer
Do you know sql
SQL
0 vote197 views1 answer
Sql server datetime
SQL
1 vote209 views3 answers
How to reset id column in sql server
SQL
1 vote186 views2 answers
Mysql type conversion
SQL
2 votes193 views1 answer
Enum in SQL Server
SQL
2 votes217 views1 answer
Oracle run_duration to number
SQL
5 votes186 views2 answers
Update all rows mysql
SQL
0 vote196 views1 answer
Output table plsql
SQL
3 votes273 views1 answer
Apex call duration
SQL
0 vote187 views1 answer
Inserting data into different tables at once in oracle sql
SQL