THE SQL Server Blog Spot on the Web

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

Rob Farley

- Owner/Principal with LobsterPot Solutions (a MS Gold Partner consulting firm), Microsoft Certified Master, Microsoft MVP (SQL Server), APS/PDW trainer and leader of the SQL User Group in Adelaide, Australia. Rob is a former director of PASS, and provides consulting and training courses around the world in SQL Server and BI topics.

Why isn’t my filtered index being used?

Hi! - Great that you've found this page, but it's no longer here! You can find the content over at: http://blogs.lobsterpot.com.au/2015/02/22/why-isnt-my-filtered-index-being-used/

Published Sunday, February 22, 2015 10:42 PM by Rob Farley

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Alvin Park said:

Well how can I register myselg on this site??

February 23, 2015 4:53 AM
 

Marcel said:

You can use parametrized dynamic SQL alternatively which is immune to injection.

February 24, 2015 5:47 PM
 

Rob Farley said:

Hi Marcel,

Yes (as per my post that I linked to above), but if you use parameters (with OPTION (RECOMPILE)) then the QO needs to come up with a plan that is general and is unlikely to use your filtered index.

February 24, 2015 6:03 PM
 

Matt said:

Nice article, this is quite subtle but very useful knowledge that needs to be thought about.

If filtered indexes are susceptible to this problem then is it a good alternative idea to embed the filter clause in a view, index the view and then query on the view? Clearly the developer has to know how to make this work safely but this may well satisfy a lot of situations where the filtered index might be applied.

June 21, 2016 6:24 AM
 

Rob Farley said:

Oh Matt - I'm totally in favour of using views to help developers make good decisions about predicates they should use. :)

June 21, 2016 6:29 AM
 

Suman said:

WOrds with friends are the best for us http://freewordswithfriendscheat.com which is easy to have.

January 24, 2018 1:27 AM
 

wef said:

http://www.chanel-outlet.co    Chanel Outlet

http://www.payless-shoes.co    payless shoes

http://www.80s-fashion.org    80's Fashion

http://www.3chathk.com    Nike Air Jordan Enfants

http://www.michaelkorsoutlet-vip.us    Michael Kors Outlet

http://www.ybreen.com    Air Jordan Retro 3

http://www.raybanshop.us    ray ban shop

http://www.promise--rings.us    Promise Rings - Official

http://www.tuxedos4u.com    populaire Nike Lunarmax

http://www.puma-outlet.net    puma outlet

http://www.coachfactoryoutlet.cc    coach factory outlet

http://www.katespade-outlet.net    katespade outlet

http://www.abirdtoldme.fr    Nike Air Force

http://www.coachbagsfactoryoutlet.us    Coach Bags Outlet

http://www.nikeschuheshop.de    NIKE Schuhe Shop

http://www.casio-watches.us    casio watches

http://www.michelewatch.us    michele watch

http://www.oakley-australia.net    oakley australia

http://www.ad29.fr    Air Jordan 10

http://www.qiqifashion.us/    qiqi fashion

http://www.birkenstocksandals.co    birkenstock sandals

http://www.burberrybagsoutlet.us    burberry bags outlet

http://www.michael-kors-shoes.us    michael kors shoes

http://www.menssunglasses.us    Sunglasses outlet sale

http://www.searchedtabsonline.com    Nike Air Jordan Enfants

http://www.raybanclubmaster.us    ray ban clubmaster sunglasses

http://www.cartier-watches.org    Cartier Watches

http://www.pumaoutlet.net    puma outlet online

http://www.hermesbag.us    hermes bag

http://www.louisvuittonoutletbox.com    louis vuitton outlet

http://www.coach-factory-outlet.org/    coach factory outlet

http://www.clearanceoutlet.us/    clearance

http://www.prada-outlet.us.com    prada outlet woodbury

meadc2.11

February 10, 2018 7:23 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

News

News? Haven't you read my blog?

My Company


Can't find something?

Contact Me

IM: rob_farley@hotmail.com
Twitter: @rob_farley
Skype: rob_farley
E: rob_farley@hotmail.com

MVP (SQL Server)




Certifications








Adelaide SQL UG

Privacy Statement