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 vote213 views1 answer
Drop procedure sql
SQL
13 votes212 views4 answers
Mysql select last 10 rows
SQL
0 vote225 views1 answer
Python mysql check if database exists
SQL
0 vote206 views1 answer
Reset keys in sql
SQL
6 votes197 views1 answer
SQL insert all columns
SQL
3 votes206 views3 answers
C# sql select
SQL
4 votes230 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote198 views1 answer
Search db for table name
SQL
0 vote194 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote218 views1 answer
Mysql last friday of current month
SQL