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

1 vote141 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote138 views2 answers
Create new table plsql
SQL
0 vote139 views1 answer
SqlFunction does not exist
SQL
0 vote137 views1 answer
Will graphql replace sql
SQL
0 vote141 views1 answer
Mysql date time string format python
SQL
0 vote148 views1 answer
Sql server on mac m1
SQL
0 vote135 views1 answer
Select in select sql
SQL
0 vote131 views1 answer
Difference between varchar and varchar2
SQL
0 vote139 views1 answer
Call object contructor and call methods of object
SQL
0 vote158 views1 answer
Add a new column into table
SQL