sql multi column index performance
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
);