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

0 vote331 views1 answer
Hw to delete a procedure in pl sql
SQL
-1 vote352 views1 answer
Concat two columns in sql server
SQL
0 vote345 views1 answer
Varchar2 length in oracle
SQL
3 votes318 views3 answers
Sql current year
SQL
17 votes321 views4 answers
Set mysql Password
SQL
27 votes351 views5 answers
Mysql set password for user
SQL
1 vote341 views1 answer
Quit mysql
SQL
0 vote368 views10 answers
Sql statement checker corrector
SQL
15 votes352 views3 answers
Postgresql change column type
SQL
0 vote357 views1 answer
Updating database in sql
SQL