Skip to Main Content
Databases Illuminated, 4th Edition
book

Databases Illuminated, 4th Edition

by Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
March 2022
Intermediate to advanced content levelIntermediate to advanced
682 pages
22h 58m
English
Jones & Bartlett Learning
Content preview from Databases Illuminated, 4th Edition

10.4 Query Optimization in Oracle

Oracle query processing begins with a parsing phase, which consists of syntax and semantic checking as described earlier, as well as a check of the shared pool area, a library that holds code for previously parsed SQL statements. If the statement is syntactically identical to one in the shared pool, Oracle does a semantic check to determine whether the statements have the same meaning. For example, two users may give the same name to tables that are actually different objects. In that case, SELECT statements for their tables may use the same syntax, but they refer to different tables, so they do not match semantically. Other environmental factors such as session settings can also cause a mismatch. If the statements ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL and Relational Theory, 3rd Edition

SQL and Relational Theory, 3rd Edition

C.J. Date

Publisher Resources

ISBN: 9781284231595