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

0 vote277 views1 answer
What is initial catalog in sql connection string
SQL
0 vote265 views1 answer
Mysql conf.d exampel
SQL
0 vote258 views1 answer
H2 auto increment and unique
SQL
10 votes267 views1 answer
Oracle all_dependencies
SQL
1 vote262 views1 answer
Altering the column name in MySQL to have a default value
SQL
1 vote277 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote269 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote303 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote254 views1 answer
Postgres call view
SQL
1 vote302 views1 answer
Sql select row with max date
SQL