Types of Conditions
•Joins – usually matches between primary keys and foreign keys. •Filter conditions – anything that isn’t a join; these conditions are the proper focus when solving tuning problems.
•