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

4 votes116 views1 answer
Sql group by year
SQL
0 vote129 views1 answer
Sql value exists in column
SQL
0 vote131 views1 answer
Oracle sql add column auto generated value
SQL
0 vote123 views1 answer
Sql create text column limited values
SQL
0 vote147 views1 answer
Command to give readonly access to a postgres sql user
SQL
28 votes121 views4 answers
Show tables mysql
SQL
31 votes135 views3 answers
Sql count
SQL
1 vote134 views1 answer
Tsql replace value in json
SQL
0 vote115 views3 answers
Joins and views sql
SQL
0 vote152 views1 answer
Mysql equivalent decode oracle
SQL