A functional index cannot be a built-in algebraic, exponential, log, or hex function.
函数索引不能是内置的代数、指数、对数或十六进制函数。
Considerations before creating a functional index.
创建函数索引的注意事项。
Create a functional index on the area of the circle.
对这个圆形区域创建一个函数索引。
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.
函数索引可以根据用户定义的类型创建。
Create a functional index that computes the city center.
创建函数索引计算城市中心。
This query plan shows an index scan using our functional index.
该查询计划显示索引扫描使用了函数索引。
A functional index can use one of the following access methods.
函数索引可以使用以下任意一种访问方法。
Using formulation calculated each man's heart functional index.
按公式计算每位受试者的心功能指数。
A functional index incurs the additional cost of function execution.
函数索引还会产生额外的函数执行开销。
The cost for storage and maintenance of a functional index can be high.
函数索引的存储和维护成本较高。
A functional index cannot be created on a UDR that returns a large object.
不能针对返回大对象的UDR创建函数索引。
This example shows how to create a functional index on the area of a circle.
本示例展示如何对圆的面积创建函数索引。
A functional index can return any standard SQL type except for large objects.
除大型对象外，函数索引可以返回任何标准sql类型。
A functional index is created on values returned by a User Defined Routine (UDR).
函数索引是根据用户定义例程(User Defined Routine,UDR)返回的值创建的。
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.
注意：优化器不会对下面这个查询使用函数索引。
We provide step-by-step instructions on how you can implement the functional index yourself.
我们将为您提供分步指导，使您能够亲自实现函数索引。
A better way to improve the performance of this query is to create a functional index on name.
改善查询性能的一种更好的方法是对name创建函数索引。
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.
函数索引对列中的数据进行转换并按照顺序保存转换后的值。
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，传递给它的参数在数量上有所限制。
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.
介绍了体育地板的基本功能指标，分析了国内体育地板的现状以及体育地板的发展趋势。
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.
如果表非常小，或者不经常执行使用函数索引的查询，那么创建函数索引可能收效甚微。
应用推荐