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

10 votes133 views1 answer
Oracle object dependencies
SQL
0 vote144 views1 answer
Liquibase update row
SQL
1 vote138 views1 answer
Pl sql insert into table
SQL
0 vote138 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote134 views1 answer
Sql create table with datetime automatically
SQL
1 vote162 views2 answers
How to add amount between date in sql
SQL
2 votes123 views1 answer
Oracle sql concatenate results into string
SQL
0 vote135 views1 answer
Null column as zero in mysql
SQL
4 votes129 views1 answer
Force drop all tables postgres
SQL
1 vote133 views1 answer
Db.Database.SqlQuery
SQL