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 vote154 views1 answer
Sql change default collation to utf8
SQL
0 vote161 views1 answer
Mysql zerofill
SQL
0 vote153 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote161 views1 answer
H2 auto increment and unique
SQL
0 vote165 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote195 views1 answer
Ceil upto 2 decimal place mysql
SQL
2 votes182 views1 answer
How to get non distinct values in sql
SQL
0 vote178 views1 answer
Difference between db.query and db.execute
SQL
2 votes174 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote156 views1 answer
Database xml sql
SQL