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 vote109 views1 answer
Download sql file of countries names
SQL
0 vote113 views1 answer
If column value is null then in mysql
SQL
0 vote115 views3 answers
Mysql keyword search
SQL
0 vote103 views1 answer
Select all columns except one sql
SQL
2 votes107 views4 answers
Mysql get all tables row count
SQL
0 vote101 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote102 views1 answer
Top frequency in sql server
SQL
5 votes124 views4 answers
Start postgres server
SQL
0 vote99 views1 answer
Execut sql python
SQL
0 vote96 views1 answer
Get sum sqlite android
SQL