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

2 votes215 views1 answer
Oracle sql drop column if exists
SQL
1 vote284 views1 answer
Opensuse restart MySQL
SQL
0 vote267 views3 answers
CONTACT FORM SQL
SQL
0 vote277 views1 answer
Java nosql sort
SQL
6 votes309 views2 answers
How to get last element sql
SQL
16 votes266 views5 answers
Select last row in sql
SQL
4 votes272 views4 answers
Start mysql
SQL
0 vote250 views1 answer
Difference between varchar and varchar2
SQL
1 vote268 views1 answer
Second last highest id in sql
SQL
1 vote265 views1 answer
Mysql strict_trans_tables
SQL