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 vote131 views1 answer
Postgresql log
SQL
2 votes137 views1 answer
Add new column not null sql server
SQL
2 votes144 views3 answers
Sql interview query questions
SQL
0 vote112 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote133 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 vote137 views2 answers
How to get max from each department in sql
SQL
15 votes128 views4 answers
Export mysql db using command line
SQL
1 vote123 views6 answers
In sql
SQL
12 votes122 views3 answers
Duplicate a column in sql
SQL
0 vote118 views3 answers
ChAnge TABLE name apex oracle
SQL