Sql double 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

9 votes385 views3 answers
Pyodbc connect to sql server
SQL
0 vote375 views1 answer
Oracle session statistics
SQL
0 vote344 views1 answer
Heavy table in mysql
SQL
0 vote366 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote356 views1 answer
Sql column as header
SQL
2 votes330 views2 answers
Insert all in sql
SQL
0 vote372 views1 answer
Mysql check if lowercase
SQL
0 vote405 views1 answer
Pl sql disable trigger
SQL
0 vote348 views1 answer
Conda install pymysql "windows"
SQL
1 vote368 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL