> Will it even cache the plan without the 1 being a parameter? Sure, by default. If you just run a query like "SELECT * FROM mytable", the database server will cache that execution plan. Parameters usually let you more effectively reuse execution plans, that's all. For example, if you had two queries without parameters, each would have its own execution plan. Now, usually, the execution plans would just be very similar, and it would make sense to have one execution plan that works for any value of the parameter. But with bit/binary values, this is not the case.
> In either case, I'd still advocate the use of schema prefixes/aliases. Me too. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
