Mechanics of Views (177)
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部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981561/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- DML ViewsView
- 8.1.1 V$ ViewsView
- 8.1.2 GV$ ViewsView
- Parallel query & viewsParallelView
- External Views (33)View
- Overview of Views (174)View
- arc177 | 賽後vp
- AtCoder Regular Contest 177
- barbajs-ViewsJSView
- Some Dictionary Views For ASMViewASM
- Views and Base Tables (243)View
- How Views are Stored (175)View
- How Views Are Used (176)View
- Dependencies and Views (180)View
- Object Views (182)ObjectView
- 我泡在GitHub上的177天Github
- 我泡在 GitHub 上的 177 天Github
- [ARC177B] Puzzle of LampsLAMP
- Oracle's V$ Views(轉)OracleView
- About Static Data Dictionary ViewsView
- Views with the Prefix USER (267)View
- Views with the Prefix ALL (268)View
- Views with the Prefix DBA (269)View
- Globalization Support Parameters in Views (178)View
- Updatable Join Views (181)View
- Overview of Materialized Views (184)ViewZed
- Refresh Materialized Views (189)ZedView
- PostgreSQL DBA(177) - Serializability Isolation(Index vs NonIndex)SQLIndex
- [ARC177F] Two AirlinesAI
- [譯]Flutter for Android Developers - ViewsFlutterAndroidDeveloperView
- Whats the difference between the v$sql* viewsSQLView
- Oracle 10G V$ViewsOracle 10gView
- [DW]An article about Materialized Views(zz)ZedView
- Extents in Materialized Views and Their Logs (18)ZedView
- Inline Views (183)inlineView
- Xamarin.Forms Views介紹(五)ORMView
- Python Web框架(URL/VIEWS/ORM)PythonWeb框架ViewORM
- Automatic Workload Repository ViewsView