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

4 votes147 views2 answers
DB::transaction
SQL
0 vote122 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
-1 vote137 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
40 votes193 views6 answers
Update table mysql
SQL
1 vote139 views4 answers
Mysqldump 1 table only
SQL
20 votes124 views5 answers
Sql show tables
SQL
4 votes164 views6 answers
Select sql
SQL
0 vote118 views1 answer
Alter table add foreign key mariadb example
SQL
13 votes119 views6 answers
Mysql update from select
SQL
2 votes143 views1 answer
Sql server find columns list in tables
SQL