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 vote180 views1 answer
Sql server datetime vs datetime2
SQL
-2 votes189 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote194 views1 answer
Access mysql database docker container shell
SQL
0 vote294 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote206 views1 answer
Search column name sql
SQL
6 votes230 views2 answers
WHERE value IS sql
SQL
0 vote168 views1 answer
Excute raw query
SQL
0 vote186 views2 answers
Postgresql variable in query
SQL
2 votes208 views1 answer
Sqlite insert if not exists
SQL
1 vote171 views1 answer
Local sql server
SQL