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.