Sql multiple column index

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 vote112 views1 answer
Print orcale
SQL
18 votes111 views3 answers
Mysql add column with default value
SQL
1 vote132 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote116 views1 answer
How to output a different column name in mysql
SQL
0 vote172 views1 answer
Order by number of character in sql
SQL
0 vote105 views1 answer
Date diff sql
SQL
0 vote117 views1 answer
Sum value by month sql
SQL
0 vote122 views1 answer
Sqlite get date only
SQL
0 vote123 views1 answer
Sql datediff month
SQL
6 votes111 views4 answers
Sqlite drop table
SQL