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 vote232 views4 answers
What is unique key in sql
SQL
1 vote218 views1 answer
Sql server 2016 reseed identity
SQL
2 votes177 views4 answers
Mysql change database character set to utf8mb4
SQL
3 votes211 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote330 views5 answers
Right join
SQL
-2 votes219 views1 answer
Remove root password mysql
SQL
6 votes213 views2 answers
Stored procedure to delete data from table in mysql
SQL
6 votes206 views3 answers
Mysql first day of year
SQL
0 vote217 views2 answers
T SQl Checking Your Username
SQL
0 vote234 views1 answer
Sql get count without group by
SQL