Sql multi column index performance

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 vote294 views1 answer
Sql get year from datetime field
SQL
5 votes305 views4 answers
Traduction
SQL
0 vote219 views1 answer
<script>alert
SQL
0 vote312 views1 answer
Mysql dump for selected row
SQL
12 votes281 views4 answers
Mysql get date difference in hours
SQL
0 vote235 views1 answer
Oracle sysdba connect as another user
SQL
28 votes312 views6 answers
Sql update
SQL
0 vote274 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote287 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
1 vote282 views1 answer
How to change owner in postgres
SQL