Sql double 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

4 votes248 views3 answers
Mysql varchar length
SQL
0 vote266 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote269 views1 answer
Alter column to not null with default value sql server
SQL
1 vote258 views1 answer
Postgres install unaccent extension
SQL
3 votes251 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote249 views1 answer
Fill up postgres db
SQL
0 vote276 views2 answers
Mysql two column combination unique
SQL
0 vote270 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
21 votes271 views1 answer
Cheatsheet for sql
SQL
0 vote262 views1 answer
How to import pymysql through jupyter notebook for windows
SQL