Abstract
All database activity is conducted in SQL, and therefore database administrators need to be intimately familiar with it. Figure 2–1 illustrates that the greatest potential for performance improvement usually lies within the software application, not within the database where the application stores its data or within the physical infrastructure where the database is housed.1
Based on a discussion in Oracle Rdb Guide to Database Performance and Tuning. Rdb is another relational database management system sold by Oracle-Oracle acquired it from Digital Equipment Corporation together with DEC/DBMS, a network database management system.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Iggy Fernandez
About this chapter
Cite this chapter
(2009). SQL and PL/SQL. In: Beginning Oracle Database 11g Administration. Apress. https://doi.org/10.1007/978-1-4302-0628-6_2
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0628-6_2
Publisher Name: Apress
Print ISBN: 978-1-59059-968-6
Online ISBN: 978-1-4302-0628-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)