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

3 votes346 views1 answer
Apex call duration
SQL
6 votes260 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote303 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote292 views1 answer
Providername system.data. mysql
SQL
0 vote250 views1 answer
Sql min
SQL
0 vote287 views1 answer
C# get sql min date
SQL
3 votes278 views1 answer
Select database in sql
SQL
0 vote262 views1 answer
Postgresql conectar
SQL
16 votes271 views6 answers
Mysql find and replace
SQL
0 vote297 views1 answer
Oracle NLS_CHARACTERSET
SQL