optimize for unknown for SQL Server 2005?

Question

I was listening to the SO podcast and they mentioned Optimize For Unknown for SQL server 2008, they also mentioned that there was something similar for SQL Server 2005. Anyone know what this is?

Answer 1

As @Mladen Prajdic mentioned, OPTIMIZE FOR UNKNOWN was only introduced in SQL Server 2008.

If you have reasonable knowledge of your query workload, OPTIMIZE FOR can be used to improve query plan caching:

http://blogs.msdn.com/sqlprogrammability/archive/2008/11/26/optimize-for-unknown-a-little-known-sql-server-2008-feature.aspx

http://decipherinfosys.wordpress.com/2007/10/23/optimize-for-query-hint-in-sql-server-2005/