Sql multiple column index

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

15 votes152 views4 answers
T-sql drop function if exists
SQL
4 votes167 views1 answer
Restart for pg_hba.conf file
SQL
10 votes324 views4 answers
Mysql if else
SQL
0 vote179 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote171 views1 answer
Get primary key of table
SQL
1 vote233 views1 answer
Size of all tables in a schema oracle
SQL
0 vote262 views1 answer
Sqlalchemy _in array sqlite
SQL
13 votes123 views2 answers
Oracle all source
SQL
11 votes167 views2 answers
Mysql set safe mode off
SQL
21 votes212 views3 answers
Average sql
SQL