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

3 votes192 views1 answer
Insert into table from another table mysql
SQL
0 vote216 views1 answer
Import mysql'
SQL
0 vote219 views1 answer
Mysql dump for selected row
SQL
7 votes217 views1 answer
Mysql unsafe update
SQL
0 vote191 views1 answer
Creation d'un trigger sql
SQL
0 vote207 views1 answer
Psql generate id in existing database
SQL
-1 vote188 views3 answers
My sql alter table
SQL
0 vote190 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
1 vote192 views1 answer
Select not matching data from two tables
SQL
0 vote192 views1 answer
Oracle session statistics
SQL