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 vote173 views1 answer
Export partttion and import in oracle
SQL
1 vote188 views1 answer
Print all records of table in mysql
SQL
0 vote181 views1 answer
Storing RGBA in mysql db
SQL
8 votes217 views6 answers
Insert command in sql
SQL
0 vote204 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote195 views1 answer
Write a query to peint the pattern P(20)
SQL
2 votes193 views1 answer
Cast string to datetime mysql
SQL
6 votes168 views5 answers
Get current date sql
SQL
1 vote185 views1 answer
Sql how to duplicate a table
SQL
0 vote190 views2 answers
Add new column after in sql
SQL