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 vote161 views2 answers
Get top 1 row of each group
SQL
2 votes165 views1 answer
Postgresql update sequence next value
SQL
0 vote237 views1 answer
Replace null value within column mysql
SQL
0 vote181 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote165 views2 answers
Create row number in sql
SQL
0 vote318 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote174 views1 answer
On update current_timestamp jpa
SQL
1 vote166 views1 answer
How to select random rows from table
SQL
3 votes177 views1 answer
Sql print all names that start with a given letter
SQL
0 vote138 views1 answer
Sql select rows with simlar names
SQL