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 vote110 views1 answer
Oracle index partition
SQL
0 vote112 views1 answer
TSQL function split string
SQL
4 votes103 views1 answer
Sql any
SQL
94 votes129 views4 answers
Create database postgres
SQL
0 vote112 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote118 views1 answer
Sql select where more than one record exists
SQL
2 votes110 views1 answer
Oracle virtual column
SQL
4 votes98 views4 answers
Rollback in sql
SQL
-1 vote57 views3 answers
Ubuntu install mssql
SQL
0 vote149 views1 answer
Psql create usr
SQL