Abstract
Every application, small or big, online or batch, OLTP or warehouse, all interact with the database using SQL. SQL could be either in the form of data manipulation language (DML) through INSERT, UPDATE, and DELETE operations; data definition language (DDL) in the form of CREATE, ALTER, and DROP; or in the form of queries where they SELECT and retrieve data from the database. SQL operations of any kind should be efficiently written to perform optimally and give good response times.
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.
Murali Vallath, Oracle 10g RAC – Grid, Services and Clustering, Digital Press, 2007.
- 2.
This does not apply to parallel operations where resource use is not directly related to the elapsed time.
- 3.
Source: Oracle Corporation.
- 4.
Source: Oracle Corporation.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Murali Vallath
About this chapter
Cite this chapter
Vallath, M. (2014). SQL Tuning. In: Expert Oracle RAC Performance Diagnostics and Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6710-2_7
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6710-2_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6709-6
Online ISBN: 978-1-4302-6710-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books