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 votes183 views3 answers
Connect python to mysql
SQL
0 vote199 views1 answer
Sql examples from framework
SQL
0 vote172 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote227 views1 answer
ALV GRID events
SQL
0 vote248 views1 answer
Postgres rename database
SQL
2 votes271 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote177 views2 answers
Sqlite unique
SQL
1 vote194 views2 answers
Sql server concat string and int
SQL
0 vote228 views1 answer
Sqlite3 not commit
SQL
10 votes212 views4 answers
Inner join in update query mysql
SQL