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 vote301 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote305 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote295 views4 answers
Mysql count table rows
SQL
8 votes285 views1 answer
Declare table variable sql server
SQL
0 vote225 views1 answer
Oracle sql replace string in clob
SQL
0 vote278 views1 answer
Fill up postgres db
SQL
0 vote304 views1 answer
Get the next column of a table in mysql
SQL
0 vote292 views1 answer
Sql count null values in all columns
SQL
0 vote271 views1 answer
Order by monthly in sql
SQL
57 votes463 views6 answers
Sql alter table
SQL