Sql double 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
Kill slow queries mysql
SQL
1 vote121 views1 answer
Get parameter value in mysql trigger
SQL
9 votes117 views4 answers
Oracle get table column names
SQL
5 votes106 views2 answers
Create function postgresql
SQL
-1 vote104 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote132 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
1 vote106 views1 answer
Md5 encryption for existing records
SQL
0 vote94 views1 answer
Create date sql
SQL
0 vote105 views1 answer
Get clob size oracle
SQL
-1 vote100 views3 answers
Check table exist postgresql
SQL