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 votes295 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
5 votes279 views1 answer
Oracle ORA-00054 origin
SQL
0 vote274 views1 answer
Oracle gather table statistics
SQL
0 vote270 views1 answer
Sql server split string and insert into table select
SQL
0 vote267 views1 answer
Mysql workbench not showing schemas
SQL
-1 vote309 views1 answer
Create view in mysql workbench
SQL
0 vote282 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote254 views1 answer
Mysql percentage of total
SQL
1 vote284 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
1 vote243 views2 answers
Delete auto increment mysql
SQL