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

4 votes255 views1 answer
Postgresql create table with index
SQL
0 vote275 views1 answer
How to print some string in mysql
SQL
0 vote252 views1 answer
List all functions and procedures in postgres query
SQL
0 vote274 views1 answer
Postgres regex word boundary
SQL
0 vote259 views1 answer
Mysql get date diff in months
SQL
22 votes251 views2 answers
Mysql show all tables
SQL
9 votes259 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote256 views1 answer
Raven ql select count
SQL
0 vote259 views1 answer
Foreign key multiple columns
SQL
1 vote238 views1 answer
Truncate table in postgresql and reset id
SQL