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

3 votes188 views2 answers
@sqlresultsetmapping
SQL
0 vote148 views1 answer
Mysql match in serialized data
SQL
-1 vote146 views1 answer
Ssms connect with connection string
SQL
0 vote152 views1 answer
Python list from sql
SQL
1 vote160 views1 answer
Sql server today minus n
SQL
5 votes158 views3 answers
Bash: mysql: command not found
SQL
0 vote160 views1 answer
Create a sql server database programmatically
SQL
1 vote161 views1 answer
Quit mysql
SQL
0 vote151 views1 answer
Database traccar
SQL
1 vote168 views2 answers
Find nth highest salary of an employee
SQL