Considerations before creating a functional index.
创建函数索引的注意事项。
This query plan shows the use of a functional index.
该查询计划展示了函数索引的使用。
Finally, execute a query that USES the functional index.
最后，执行查询，该查询将使用函数索引。
A functional index can be created on user defined types.
函数索引可以根据用户定义的类型创建。
This query plan shows an index scan using our functional index.
该查询计划显示索引扫描使用了函数索引。
Using formulation calculated each man's heart functional index.
按公式计算每位受试者的心功能指数。
A functional index incurs the additional cost of function execution.
函数索引还会产生额外的函数执行开销。
A functional index cannot be created on a UDR that returns a large object.
不能针对返回大对象的UDR创建函数索引。
A functional index is created on values returned by a User Defined Routine (UDR).
函数索引是根据用户定义例程(User Defined Routine,UDR)返回的值创建的。
A functional index cannot be a built-in algebraic, exponential, log, or hex function.
函数索引不能是内置的代数、指数、对数或十六进制函数。
A UDR used by a functional index cannot have arguments that are collection data types.
如果将某个UDR用于函数索引，则该U DR不能使用集合数据类型作为参数类型。
Note: Here is a query for which the optimizer cannot consider using the functional index.
注意：优化器不会对下面这个查询使用函数索引。
A better way to improve the performance of this query is to create a functional index on name.
改善查询性能的一种更好的方法是对name创建函数索引。
In this example we show you how to create a functional index that USES the R-Tree access method.
在本例中，我们将向您展示如何创建使用r - Tree访问方法的函数索引。
You have now learned the definition of a functional index and have seen how and when to use them.
您已经了解了函数索引的定义以及其使用方式和使用时机。
A functional index transforms the data in a column and stores the derived values in sorted order.
函数索引对列中的数据进行转换并按照顺序保存转换后的值。
You must explicitly specify NOT VARIANT when you define a UDR that is used for a functional index.
当定义udr并将之用于函数索引时，您必须显式将其指定为NOTVARIANT。
And also proposes the management method by using the functional index tree and adopting the chunks.
提出了运用功能索引树进行集中管理，并采用通过伪指令进行模块调用的方式。
Each example provides step-by-step instructions so that you can implement the functional index yourself.
每个例子都附带了分步指导，根据这些指导，您将能够亲自实现函数索引。
There are limitations on the number of arguments that can be passed to a UDR used by a functional index.
对于用于函数索引的UDR，传递给它的参数在数量上有所限制。
A functional index can specify different access methods that include B-Tree, R-Tree, and user-defined access methods.
函数索引可以指定各种不同的访问方法，包括B -Tree、r - Tree和用户定义的访问方法。
The DBMS automatically manages the functional index and applications need not include logic to manage the upper case data.
DBMS将自动管理函数索引以及不需要包含逻辑来管理大写形式数据的应用程序。
To satisfy this query, you must compute the geographical city center, so create a functional index that computes this value.
要满足这个查询，必须计算地理城市中心，因此，需要创建一个函数索引来计算这个值。
This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.
这说明，在创建或删除函数索引时，执行索引的表中始终持有一个排他锁。
When each functional index is created, its associated UDR is executed to pre-process the images and store the results as the index key.
在创建函数索引时，将执行与其相关的UDR来对图像进行预处理，并将结果作为索引键保存。
The postoperative functional recovery of the rear limbs of rats was dynamically observed by using sciatic nerve functional index (SFI).
并动态观察坐骨神经功能指数(SFI)以了解后肢恢复情况。
This paper introduces the basic functional index and status of the sports floors, and finally proposes the trend of sports floors in China.
介绍了体育地板的基本功能指标，分析了国内体育地板的现状以及体育地板的发展趋势。
Results: The recovery of sciatic functional index, Lat and MAP were significantly higher in all time point in EGF, NGF groups than that in control groups.
结果：坐骨神经功能指数恢复率各时间点egf组、NGF组均明显优于对照组，EGF与NGF之间无明显差异。
Index options like UNIQUE and CLUSTER, and access methods like B-Tree, R-Tree and user-defined access methods can apply to both functional and non-functional indexes.
诸如unique和CLUSTER等索引选项，以及B -Tree、r -Tree等访问方法和用户定义的访问方法，可以同时应用于函数索引和非函数索引。
If the tables are small or if the frequency of queries that would make use of the functional index is small, then you may not benefit from creating a functional index.
如果表非常小，或者不经常执行使用函数索引的查询，那么创建函数索引可能收效甚微。
应用推荐