Abstract
System and object statistics are essential because they describe both the system running the database engine and the data stored in the database. In fact, a query optimizer that is aware of only the SQL statement to be processed and the structure of the objects referenced by the SQL statement is not able to provide efficient execution plans. Simply put, it has to be able to quantify the amount of data to be processed.
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.
Similar content being viewed by others
Rights and permissions
Copyright information
© 2008 Christian Antognini
About this chapter
Cite this chapter
(2008). System and Object Statistics. In: Troubleshooting Oracle Performance. Apress. https://doi.org/10.1007/978-1-4302-0498-5_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0498-5_4
Publisher Name: Apress
Print ISBN: 978-1-59059-917-4
Online ISBN: 978-1-4302-0498-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books