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 vote244 views1 answer
Custom row number
SQL
0 vote240 views1 answer
Search In the Database using Text
SQL
0 vote240 views1 answer
Mysql export search results
SQL
11 votes236 views1 answer
Ddl materialized view
SQL
0 vote231 views1 answer
Mysql server not running
SQL
0 vote240 views2 answers
Update query with between in mysql
SQL
3 votes231 views3 answers
List columns in table postgres
SQL
0 vote234 views1 answer
Denormalise SQL command
SQL
0 vote265 views1 answer
Min:sec datediff mssql
SQL
1 vote230 views2 answers
Mysql join two tables
SQL