Boek
One of the most important challenges faced by Oracle database administratorsand Oracle developers is the need to tune SQL statements so that they executeefficiently. Poorly tuned SQL statements are one of the leading causes ofsubstandard database performance and poor response time. SQL statements thatperform poorly result in frustration for users and can even prevent a companyfrom serving its customers in a timely manner. In this book Mark Gurry shareshis indepth knowledge of Oracles SQL statement optimizers. Marks knowledgeis the result of many hardfought tuning battles during his many years ofproviding Oracle tuning services to clients. Mark provides insights into theworkings of the rulebased optimizer that go well beyond what the rules tellyou. Mark also provides solutions to many common problems that occur with boththe rulebased and costbased optimizers. In addition to the specific problemsolution scenarios for the optimizers Mark provides a number of handy SQLtuning tips. He discusses the various optimizer hints telling you when theycan be used to good effect. Finally Mark discusses the use of the DBMS_STATSpackage to manage database statistics and the use of outlines to specifyexecution plans for SQL statements in thirdparty applications that you cantotherwise modify. «
Boeklezers.nl is een netwerk voor sociaal lezen. Wij helpen lezers nieuwe boeken en schrijvers ontdekken, en brengen lezers met elkaar en schrijvers in contact. Meer lezen »
Er zijn nog geen recensies voor dit boek.