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

5 votes118 views1 answer
Minecraft java port number
SQL
1 vote112 views1 answer
Mysql not supported auth mode
SQL
0 vote119 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote126 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote120 views1 answer
Sql find column name like
SQL
0 vote129 views1 answer
Netstat -tln mysql
SQL
0 vote109 views1 answer
Add column to table with default value plsql
SQL
0 vote100 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
3 votes105 views2 answers
Oracle for loop
SQL
0 vote117 views1 answer
Forcefully delete a row in mysql which has references
SQL