THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » New Features » SQL Server Performance   (RSS)
  • Filtered Indexes

    In SQL Server 2008, you can have what is called a ''Filtered Index''.  What does this mean?  An index may be created for a subset of rows in your table.  For instance you could create a filtered index for a ''state'' column if the value is ''CA'' for California; the rest of the states would not have a value.  When you create ...
    Posted to Rick Heiges (Weblog) by RickHeiges on March 18, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement