>We don't know. I was trying to see if it was even possible before >attempting.
I very much doubt it is going to help you. Stored procedures are faster because they are preplanned and precompiled, but with all the LIKE statements it is pretty much impossible to use a partial indexscan on the table, so there is nothing to plan and the compile time will be negligible compared to the execution time. Whatever you do, this statement is going to scan all of the table. Only a full text index or partial indexes can help you. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:202551 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
