What is a “functional” versus an “indexed” lookup?
There are two ways the kernel can query the text index. In the first – and most common – case, the kernel asks the text index for all the rowids that satisfy a particular text search. These rowids are returned in blocks. In the second, the kernel passes individual rowids to the text index, and asks whether that particular rowid satisfies a certain text criterion. The second is known as a functional lookup, and is most commonly done where there is a very selective structured clause, so that only a few rowids must be checked against the text index.
There are two ways the kernel can query the text index. In the first and most common case, the kernel asks the text index for all the rowids that satisfy a particular text search. These rowids are returned in batches. In the second, the kernel passes individual rowids to the text index, and asks whether that particular rowid satisfies a certain text criterion. The second is known as a functional lookup, and is most commonly done where there is a very selective structured clause, so that only a few rowids must be checked against the text index.
Related Questions
- which type of resume?, functional resume, chronological, how much should i pay?, hardcopy versus online resume, dos and don s, what employers look for, cover letters, thank you letters, paper and envelopes which type of resume?
- Why functional training versus weight machines?
- What is a "functional" versus an "indexed" lookup?