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 vote161 views2 answers
Mysql extract number from string
SQL
3 votes127 views2 answers
Postgres download
SQL
0 vote155 views1 answer
Merge clause with inner join
SQL
19 votes140 views6 answers
What is mySQL
SQL
0 vote141 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
1 vote136 views1 answer
Oracle add proxy
SQL
8 votes149 views3 answers
SQL column name
SQL
0 vote139 views1 answer
Sql server update top n records
SQL
-1 vote142 views1 answer
Auto increment psql not primary key
SQL
0 vote125 views1 answer
Phpmyadmin mysql conflict
SQL