Question: what are the query optimization techniques?
Answer: OR in the Join Predicate/WHERE Clause Across Multiple Columns. SQL Server can efficiently filter a data set using indexes via the WHERE clause or any combination of filters that are separated by an AND operator. ... 
Over-Indexing a Table. ... 
Under-Indexing a Table. ... 
No Clustered Index/Primary Key.