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

2 votes148 views1 answer
Columns Present in a table
SQL
1 vote141 views1 answer
Mysql show table character set
SQL
0 vote147 views1 answer
Windows services sql
SQL
0 vote148 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote160 views1 answer
Time mysql w3
SQL
9 votes174 views3 answers
Date format in sql
SQL
1 vote152 views1 answer
Search for replace in mysql
SQL
0 vote142 views1 answer
Groupby error in mysql
SQL
-1 vote161 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
1 vote167 views1 answer
How to delay stored procedure execution in sql server
SQL