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

1 vote392 views1 answer
Delete mysql ubuntu 20.04
SQL
1 vote343 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote336 views1 answer
1 column values in to 1 single row in sql
SQL
2 votes369 views1 answer
Can you use a where clause for a child query
SQL
3 votes372 views1 answer
Get current month last date in sql server
SQL
14 votes352 views1 answer
Excel is not a database
SQL
0 vote367 views1 answer
Openquery join two tables
SQL
8 votes370 views1 answer
Check mysql version phpmyadmin
SQL
0 vote367 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote330 views1 answer
SQL Server format datetime
SQL