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 vote320 views1 answer
Sql change column in existing table
SQL
0 vote328 views1 answer
Login failed for user sql server
SQL
1 vote307 views1 answer
Sample clause in sql
SQL
3 votes301 views2 answers
Oracle apex view logs
SQL
0 vote354 views1 answer
Pl sql join 3 tables
SQL
0 vote320 views1 answer
Oracle cpu metric
SQL
6 votes313 views1 answer
Oracle list primary key
SQL
5 votes297 views2 answers
Copy data from one database to another
SQL
1 vote288 views1 answer
Add time to date sql
SQL
1 vote323 views1 answer
Select users with same username
SQL