Sql multiple column 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 vote300 views1 answer
Drop function
SQL
2 votes270 views1 answer
Convert series number to date in sql
SQL
1 vote309 views1 answer
Wherein mysql
SQL
5 votes284 views1 answer
Pl sql asynchronous procedure calls
SQL
10 votes279 views1 answer
How to import database in mysql by cmd
SQL
1 vote308 views1 answer
Get create table query existing table mysql
SQL
1 vote310 views1 answer
Oracle check table lock
SQL
0 vote283 views2 answers
Sql server select first day of previous year
SQL
0 vote279 views1 answer
Oracle archivemode
SQL
0 vote290 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL