首页 > IT基础架构 > 网络安全 > Mechanics of Views (177)

Mechanics of Views (177)

原创 网络安全 作者:tsinglee 时间:2007-11-10 15:41:42 0 删除 编辑

Oracle stores a view’s definition in the data dictionary as the text of the query that
defines the view. When you reference a view in a SQL statement, Oracle:
1. Merges the statement that references the view with the query that defines the view
2. Parses the merged statement in a shared SQL area
3. Executes the statement
Oracle parses a statement that references a view in a new shared SQL area only if no
existing shared SQL area contains a similar statement. Therefore, you get the benefit of
reduced memory use associated with shared SQL when you use views.

当在SQL语句中引用了视图时 , Oracle做了以下工作 :
1. 将引用了视图的语句与视图的定义语句整合为一个语句
2. 在共享 SQL 区解析整合后的语句
3. 执行语句


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

  • 博文量
  • 访问量