消除SQL聚簇索引寻求嵌套在可选的外部应用中

I'm running SQL Server 2008. I've built a large search query (contained in a user defined function) with many optional parameters. A simplified version of the result is something like:I'm running SQL Server 2008. I've built a large