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

14 votes256 views1 answer
Excel is not a database
SQL
0 vote158 views2 answers
Spring properties file for db
SQL
0 vote196 views1 answer
Sql transact create cursor with dynamic tables
SQL
2 votes198 views2 answers
Mysql get time from datetime
SQL
0 vote211 views1 answer
How to find table lock and row lock in mysql
SQL
1 vote197 views1 answer
Add many column to sap iq table
SQL
8 votes226 views1 answer
Oracle current date plus 1 month
SQL
3 votes197 views1 answer
Oracle drop user
SQL
0 vote225 views1 answer
Call function in query sql server
SQL
0 vote216 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL