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

1 vote182 views1 answer
Mysql show attributes of a table
SQL
1 vote161 views1 answer
How to get mysql db size
SQL
0 vote136 views1 answer
Print sum of values sql
SQL
0 vote190 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote156 views1 answer
Oracle index hint multiple tables example
SQL
0 vote185 views1 answer
SQL column name Oracle
SQL
1 vote163 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
1 vote178 views1 answer
Oracle compile schema
SQL
0 vote188 views1 answer
Oracle lower in where clause
SQL
0 vote178 views1 answer
Closure in sql
SQL