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

0 vote329 views1 answer
Psql generate id in existing database
SQL
6 votes334 views1 answer
How to get the size of the database in postgresql
SQL
0 vote305 views3 answers
Between keyword sql
SQL
2 votes360 views1 answer
Query to check cpu utilization in oracle database
SQL
13 votes326 views6 answers
Mysql remove duplicates
SQL
-1 vote276 views1 answer
Oracle db list usernames
SQL
0 vote324 views1 answer
Restore backup mysql .gz
SQL
0 vote294 views1 answer
Renommer table sql
SQL
0 vote269 views1 answer
Expose db in virtualbox
SQL
0 vote340 views2 answers
Create-toys-table-with-toy_name-column
SQL