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

42 votes267 views6 answers
Install beautifulsoup
SQL
1 vote179 views1 answer
Media sql
SQL
0 vote222 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
1 vote194 views1 answer
Postgres first_value in gropby
SQL
7 votes235 views1 answer
Xampp reset mysql
SQL
0 vote203 views1 answer
Sqlserver now
SQL
0 vote211 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote202 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote174 views1 answer
Drop all tables in azure sql database
SQL
5 votes219 views4 answers
Mysql update column with value from another table
SQL