Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
Partial index
open-in-new
<h2 id="support">Support</h2> <p>In <a href="/facts/Microsoft_SQL_Server/eCdt2JBL">SQL Server</a>, this type of index is called a <i>filtered index</i>.<a class="footnote-ref" id="fnref:1" href="#fn:1"><sup>1</sup></a> </p><p>Partial indexes have been supported in <a href="/facts/PostgreSQL/LHdXuHfl">PostgreSQL</a> since version 7.2, released in February 2002.<a class="footnote-ref" id="fnref:2" href="#fn:2"><sup>2</sup></a> </p><p><a href="/facts/SQLite/1PwYzIft">SQLite</a> supports partial indexes since version 3.8.0.<a class="footnote-ref" id="fnref:3" href="#fn:3"><sup>3</sup></a> </p><p><a href="/facts/MongoDB/9myQKGoY">MongoDB</a> supports partial indexes since version 3.2.<a class="footnote-ref" id="fnref:4" href="#fn:4"><sup>4</sup></a> </p> <h2 id="external-links">External links</h2> <ul><li><a href="http://db.cs.berkeley.edu/papers/ERL-M89-17.pdf">The Case For Partial Indexes</a></li></ul> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>SQL Server 2008 Documentation: Filtered Index Design Guidelines. Microsoft TechNet. <a href="https://technet.microsoft.com/en-us/library/cc280372.aspx" target="_blank">https://technet.microsoft.com/en-us/library/cc280372.aspx</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>"PostgreSQL Documentation: Release Notes: Release 7.2". PostgreSQL. Retrieved 2009-10-09. Enable partial indexes (Martijn van Oosterhout) <a href="http://www.postgresql.org/docs/current/static/release-7-2.html" target="_blank">http://www.postgresql.org/docs/current/static/release-7-2.html</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> <li id="fn:3"><p>"Partial Indexes". Retrieved 2014-02-04. <a href="http://www.sqlite.org/partialindex.html" target="_blank">http://www.sqlite.org/partialindex.html</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li> <li id="fn:4"><p>MongoDB V302 Release Notes. <a href="https://docs.mongodb.org/manual/release-notes/3.2/" target="_blank">https://docs.mongodb.org/manual/release-notes/3.2/</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li> </ol>