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

0 vote317 views1 answer
CREATE MULTIPLE FK
SQL
0 vote393 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
2 votes357 views1 answer
Check isolation level in mysql
SQL
0 vote409 views1 answer
Consecutive numbers sql
SQL
0 vote391 views3 answers
CONTACT FORM SQL
SQL
0 vote335 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote385 views1 answer
Last date for each user sql
SQL
0 vote380 views1 answer
Sql last 3 rows
SQL
0 vote417 views1 answer
Copy row from db to db mysql
SQL
1 vote387 views1 answer
How to use db.execute
SQL