SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 25, 2008.

  1. Anonymous New Member

    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">

Share This Page