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

6 votes264 views3 answers
Mysql remove user privileges
SQL
0 vote216 views1 answer
Select year from dual oracle
SQL
0 vote198 views1 answer
Inserting data into different tables at once in oracle sql
SQL
2 votes247 views1 answer
Username sql
SQL
0 vote260 views1 answer
000webhost database values insert
SQL
1 vote203 views1 answer
Search for replace in mysql
SQL
1 vote243 views1 answer
Select from describe sql
SQL
0 vote208 views1 answer
Mysql_num_fields in mysqli
SQL
-1 vote234 views2 answers
Sql truncate number
SQL
0 vote192 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL