This type of plug-in-provided function uses a logical predicate to specify search conditions.

Normally a plug-in index is used for retrieval. However, a SCAN TYPE plug-in-provided function can work even when no plug-in index is defined, or when a plug-in index is not available during retrieval.

This type of plug-in-provided function uses a logical predicate (IS TRUE only) to specify search conditions. It always uses a plug-in index for retrieval. This is called an index-type plug-in-dedicated function.

An INDEX SCAN TYPE plug-in-provided function results in an error if a plug-in index is undefined or unavailable.

This type of plug-in-provided function uses a logical predicate to specify search conditions.

If a plug-in index is defined, the index can be used for retrieval, but the entire range of index is searched. Therefore, if the condition is provided only by the FULL SCAN TYPE plug-in-provided function, the plug-in index is used for retrieval. If there is another condition, the function checks that condition to obtain the result without using the plug-in index.