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 vote75 views1 answer
How to check oracle index table
SQL
1 vote129 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
-1 vote116 views1 answer
Add column alter table default value
SQL
5 votes116 views1 answer
Sql select ciunt
SQL
12 votes118 views2 answers
Insert multiple rows from another table sql
SQL
8 votes107 views2 answers
Phpmyadmin password
SQL
2 votes114 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote75 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
2 votes121 views2 answers
Created at and updated at in mysql
SQL
1 vote126 views2 answers
Mysql switch case
SQL