Partial index
id:
partial-index-199-1072757
title:
Partial index
text:
In databases, a partial index, also known as filtered index is an index which has some condition applied to it so that it includes a subset of rows in the table. This allows the index to remain small, even though the table may be rather large, and have extreme selectivity. Suppose you have a transaction table where entries start out with STATUS = 'A' (active), and then may pass through other statuses before reaching a final status, 'F', at which point it is no longer likely to be processed again
brand slug:
wiki
category slug:
encyclopedia
description:
original url:
https://en.wikipedia.org/wiki/Partial_index
date created:
date modified:
2022-09-20T11:52:27Z
main entity:
{"identifier":"Q7140373","url":"https://www.wikidata.org/entity/Q7140373"}
image:
fields total:
13
integrity:
13