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

31 votes345 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote344 views1 answer
Sql waitfor
SQL
3 votes356 views2 answers
Update Query in SQL Server
SQL
0 vote387 views1 answer
Pl sql disable trigger
SQL
-1 vote335 views3 answers
Check table exist postgresql
SQL
0 vote285 views1 answer
Check id exist or not in sql
SQL
0 vote327 views1 answer
SQL get max per id
SQL
2 votes373 views1 answer
Sql server check for value in multiple columns
SQL
0 vote420 views1 answer
Select * from mysql.proc
SQL
2 votes389 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL