4 Kicks

Introduction to Filtered Index - Improve performance(blog.sqlauthority.com)

submitted by pinaldavepinaldave(9662) 3 years, 8 months ago

Filtered Index is a new feature in SQL SERVER 2008. Filtered Index is used to index a portion of rows in a table that means it applies filter on INDEX which improves query performance, reduce index maintenance costs, and reduce index storage costs compared with full-table indexes. When we see an Index created with some WHERE clause then that is actually a FILTERED INDEX. I am sure this feature will change how the indexes are created in SQL Server.

1 comment |category: |Views: 21

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
jeetjeet(0) - rsivamrsivam(0) - cdbhcdbh(0) - pinaldavepinaldave(9662)
Comments:

posted by rsivamrsivam(0) 3 years, 8 months ago 0

I tried on my sql server 2008 CTP which had more than 10K row. It worked well.

Reply

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?