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

0 vote234 views1 answer
Check if due date is less than todays date sql
SQL
19 votes289 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote271 views1 answer
Oracle create package body
SQL
0 vote311 views1 answer
Reset postgres table index to next max value
SQL
0 vote312 views1 answer
Postgresql inheritance
SQL
0 vote276 views1 answer
Sql drop default
SQL
0 vote281 views1 answer
Python mysqlclient library not found for -lssl
SQL
4 votes281 views1 answer
Id primary key auto generated
SQL
0 vote288 views1 answer
Run mssql server terminal
SQL
1 vote282 views1 answer
Oracle split string
SQL