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 vote235 views1 answer
Hierarchal database table
SQL
6 votes181 views1 answer
To count number of rows in SQL table
SQL
2 votes184 views2 answers
Oracle no data found error code
SQL
0 vote181 views1 answer
Mysql date only no time
SQL
-1 vote183 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote183 views1 answer
Mysql case when null
SQL
0 vote192 views1 answer
Sql alter table add column if exists
SQL
4 votes143 views2 answers
Select todays data postgres query
SQL
9 votes202 views6 answers
Oracle substring
SQL
0 vote221 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL