SQL Performance - Slow Query

• Queries will run slower when using joins as opposed to finite variable filter values
• Eg. Inner join on a table with a single record will take longer than selecting the value of the record and using it as a filter on the table