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

1 vote156 views1 answer
Sql insert for each distinct value
SQL
3 votes172 views2 answers
Postgres show table schema
SQL
0 vote190 views1 answer
Check if mysql db is used
SQL
0 vote173 views1 answer
Connect by query in oracle
SQL
3 votes135 views1 answer
Postgresql where current year
SQL
2 votes215 views1 answer
Tcl in sql
SQL
19 votes174 views6 answers
Sql server drop table if exists
SQL
2 votes212 views2 answers
Mysql search for column name in all tables
SQL
2 votes164 views1 answer
Change primary key sql
SQL
0 vote164 views1 answer
Mysql count grouped rows
SQL