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

1 vote304 views1 answer
Mssql string length
SQL
4 votes338 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote340 views1 answer
Alter table myisam to innodb
SQL
1 vote344 views1 answer
Sample in sql
SQL
0 vote343 views1 answer
Can't connect to postgresql mac os
SQL
5 votes337 views1 answer
Oracle scan source ddl
SQL
0 vote334 views1 answer
SQL Server modify_timestamp trigger
SQL
2 votes344 views2 answers
Change varchar length mysql
SQL
0 vote349 views1 answer
Mysql persistence.xml
SQL
1 vote347 views1 answer
Can not connect to mysql server
SQL