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 vote139 views2 answers
Plsql function that return a table
SQL
0 vote141 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
1 vote128 views2 answers
Sql groub by count
SQL
0 vote132 views1 answer
Python list from sql
SQL
8 votes136 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote126 views1 answer
Write SQL in ruby on rails
SQL
0 vote136 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote175 views1 answer
Sql server is not
SQL
0 vote132 views1 answer
Null column as zero in mysql
SQL
18 votes133 views4 answers
Uninstall mysql on ubuntu
SQL