SQL Server Performance - consideration on unique index or filtered index.

It is no doubt that when a database consists ' well-designed ' indexes can reduce disk I/O operations and consume fewer system resources therefore improving query performance. You might be wondering I'm going back to basics for indexes! So when the database consists filtered indexes, they are very handy to optimize the performance. So where these filtered indexes stored and why they are helpful? In the execution of variety of queries that consists SELECT, UPDATE or DELETE statements, SQL optimizer...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2008/09/25/4555.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=4555" width="1" height="1">