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.
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
Notes
- 1.
Based on a discussion in Oracle Rdb Guide to Database Performance and Tuning.
- 2.
It’s possible to create a function-based index for the upper(first_name) and upper(last_name) columns.
- 3.
The URL is http://docs.oracle.com .
- 4.
Such a query is called a Cartesian product.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Ignatius Fernandez
About this chapter
Cite this chapter
Fernandez, I. (2015). SQL and PL/SQL by Example. In: Beginning Oracle Database 12c Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0193-0_2
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0193-0_2
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0194-7
Online ISBN: 978-1-4842-0193-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books