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

8 votes166 views1 answer
Oracle search stored procedures for text
SQL
4 votes193 views6 answers
Select sql
SQL
0 vote142 views1 answer
How to find unique key in sql
SQL
0 vote153 views2 answers
Homebrew nysql launch
SQL
0 vote227 views1 answer
Oracle db get table sizes
SQL
0 vote156 views1 answer
Sql query contains multiple ids
SQL
0 vote155 views1 answer
Generate sequence number in sql server
SQL
2 votes146 views1 answer
Update with join sql server
SQL
0 vote156 views1 answer
Psql get table data types
SQL
1 vote165 views1 answer
Raw query must include primary key
SQL