Sql multi column index performance

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 vote207 views1 answer
Rabbitmq ui not working
SQL
0 vote190 views2 answers
Sql drop view if exists
SQL
2 votes202 views1 answer
Postgresql create schema in specific database
SQL
0 vote275 views1 answer
Mysql loop through databases and execute query
SQL
1 vote190 views2 answers
Drop function in sql
SQL
1 vote268 views1 answer
Sqlite create index
SQL
0 vote196 views1 answer
Sql server set complex constraints
SQL
0 vote189 views1 answer
Oracle current timestamp
SQL
1 vote208 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote198 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL