Sql multiple column 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 vote195 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote163 views1 answer
Difference between 2 query results sql server
SQL
2 votes109 views1 answer
Sql float to int
SQL
1 vote147 views1 answer
Oracle user last connected
SQL
8 votes153 views2 answers
Mysql grant all privileges to user from any host
SQL
4 votes156 views3 answers
Employee name starting with in sql
SQL
0 vote172 views1 answer
Pl/pgsql declare variable
SQL
1 vote160 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote142 views1 answer
Flask sqlalchemy update row
SQL
0 vote159 views1 answer
Oracle calculate statistics on partition
SQL