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

18 votes196 views6 answers
Drop table if exists
SQL
0 vote184 views1 answer
Mysql identified by syntax error
SQL
10 votes184 views1 answer
Create table oracle
SQL
3 votes257 views1 answer
Oracle function
SQL
0 vote224 views2 answers
Postgres isnull
SQL
0 vote189 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote182 views1 answer
Store select query result in variable sql server
SQL
4 votes288 views1 answer
Select first and last row sql
SQL
-1 vote207 views1 answer
Add bool column in sql
SQL
0 vote248 views1 answer
Sqlite trim
SQL