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

7 votes312 views1 answer
Forge server hosting
SQL
0 vote318 views1 answer
Postgres where
SQL
10 votes323 views4 answers
Sql pagination
SQL
1 vote304 views1 answer
Mysql collation
SQL
1 vote333 views1 answer
Retrieve meaning
SQL
4 votes311 views1 answer
Postgresql change default value
SQL
0 vote336 views1 answer
Sql shell psql cannot enter password
SQL
0 vote322 views1 answer
Add unique constraint sql server multiple columns
SQL
1 vote343 views1 answer
Oracle enable job
SQL
25 votes347 views3 answers
How to use a database to see tables mysql
SQL