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

42 votes363 views6 answers
Sql query duplicate rows
SQL
0 vote304 views1 answer
Mssql dockere
SQL
-1 vote300 views1 answer
How to change the auto increment in existing table mysql
SQL
10 votes304 views2 answers
Tsql merge example
SQL
0 vote279 views1 answer
Sql server udf performance
SQL
0 vote294 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote294 views1 answer
Mysql set variable to today's date
SQL
4 votes289 views2 answers
Sql server date now
SQL
1 vote285 views1 answer
Set statiscis on in ssms
SQL
0 vote311 views1 answer
.sql File Run in PSQL
SQL