Partial index
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 ('P' for pending, 'W' for "being worked on") before reaching a final status, 'F', at which point it is no longer likely to be processed again.
Partial index
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 ('P' for pending, 'W' for "being worked on") before reaching a final status, 'F', at which point it is no longer likely to be processed again.
has abstract
In databases, a partial index, ...... oyee(age) where salary > 2100;
@en
部分インデックス (英: partial index) は関 ...... oyee(age) WHERE salary > 2100;
@ja
Link from a Wikipage to an external page
Wikipage page ID
Wikipage revision ID
717,550,691
hypernym
type
comment
In databases, a partial index, ...... likely to be processed again.
@en
部分インデックス (英: partial index) は関 ...... の行のその列が NULL であるならば大きな利益が見込める。
@ja
label
Partial index
@en
部分インデックス
@ja