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

3 votes204 views2 answers
Mysql import gz
SQL
1 vote187 views1 answer
Postgresql filter on
SQL
0 vote239 views1 answer
Drop table BigQuery table columns
SQL
6 votes229 views3 answers
Rename column ORACLE
SQL
3 votes335 views9 answers
Linq to sql converter online
SQL
1 vote202 views2 answers
Sql for date greater than
SQL
0 vote195 views1 answer
Mysql utc timestamp
SQL
2 votes194 views3 answers
How to pass password mysql command line
SQL
1 vote194 views1 answer
Sql server epoch to datetime
SQL
1 vote179 views1 answer
MySQL AND Operator
SQL