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

1 vote134 views2 answers
Update with inner join sql server
SQL
0 vote111 views2 answers
Postgresql display subquery as json
SQL
0 vote134 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote133 views1 answer
Optimize sql query
SQL
0 vote94 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
2 votes126 views1 answer
Sql like variable
SQL
0 vote237 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote122 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote149 views2 answers
Amazon linux postgresql client
SQL
24 votes135 views6 answers
Sql change table name
SQL