A Filtered Index is an optimized form of non clustered index. A Filtered Index allows us to create a filter to index a subset of rows within a table.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What is Filtered Index ?
Monday, March 21, 2011
A Filtered Index is an optimized form of non clustered index. A Filtered Index allows us to create a filter to index a subset of rows within a table.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
What are Sparse columns ?
They are ordinary columns optimized for storage of null values, thereby reducing storage physical space.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Subscribe to:
Posts (Atom)
LinkWithin
