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 vote106 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
11 votes153 views2 answers
Oracle saurce code
SQL
2 votes154 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
18 votes141 views2 answers
Sql inner join
SQL
0 vote137 views1 answer
How to count with except in psql
SQL
8 votes129 views1 answer
Sql remove characters from string right
SQL
0 vote132 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote133 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote186 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
1 vote172 views1 answer
Add sequence postgres
SQL