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

1 vote123 views1 answer
Mysql show data from table
SQL
1 vote140 views1 answer
UseSqlServer no definition
SQL
1 vote123 views1 answer
Select if then postgresql
SQL
0 vote154 views1 answer
Select top values sql
SQL
12 votes122 views3 answers
Duplicate a column in sql
SQL
0 vote117 views1 answer
Order by monthly in sql
SQL
0 vote140 views1 answer
Install package for sqlserver in asp.net core
SQL
3 votes124 views4 answers
Show sql server database
SQL
0 vote114 views1 answer
Mysql last 6 months
SQL
4 votes121 views1 answer
Fetch first 10 rows in oracle sql developer
SQL