ITPub博客

首页 > IT基础架构 > 网络安全 > Uses of Function-Based Indexes (200)

Uses of Function-Based Indexes (200)

原创 网络安全 作者:tsinglee 时间:2007-11-15 09:25:37 0 删除 编辑

Function-based indexes provide an efficient mechanism for evaluating statements that
contain functions in their WHERE clauses. The value of the expression is computed and
stored in the index. When it processes INSERT and UPDATE statements, however,
Oracle must still evaluate the function to process the statement.

Function-based indexes defined on UPPER(column_name) or LOWER(column_name) can facilitate
case-insensitive searches.

A function-based index can also be used for a globalization support sort index that
provides efficient linguistic collation in SQL statements.

使用函数索引
1. 如果一个 SQL 语句的 WHERE 子句中使用了函数,那么建立相应的函数索引是提高数据访问性能
2. 使用 UPPER(column_name) 或 LOWER(column_name) 函数建立函数索引需要注意大小敏感性

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-982469/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1900002