Sql multi column index performance

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

2 votes138 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote100 views1 answer
Check if due date is less than todays date sql
SQL
0 vote157 views1 answer
Sql server insert inner join
SQL
1 vote141 views1 answer
Set autoincrement to 0
SQL
1 vote144 views1 answer
Replace all numbers in mysql
SQL
0 vote129 views1 answer
Opensuse stop MySQL
SQL
3 votes204 views2 answers
Oracle privileges users
SQL
19 votes140 views5 answers
Change column name mysql command line
SQL
1 vote148 views1 answer
Postgresql float 2 decimal places
SQL
6 votes150 views2 answers
Where clause in sql
SQL