skip to content
Oracle high-performance SQL tuning Preview this item
ClosePreview this item
Checking...

Oracle high-performance SQL tuning

Author: Donald K Burleson
Publisher: Berkeley, Calif. : Osborne/McGraw-Hill, ©2001.
Edition/Format:   Print book : English : 1st edView all editions and formats
Summary:

This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement.

Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Material Type: Internet resource
Document Type: Book, Internet Resource
All Authors / Contributors: Donald K Burleson
ISBN: 0072190582 9780072190588
OCLC Number: 47920903
Notes: Includes index.
At head of title: Oracle Press.
"Covers Oracle database releases 7.x, 8, and 8i"--Cover.
Description: xxvi, 575 pages : illustrations ; 24 cm
Contents: 1. Introduction to SQL --
2. Overview of Oracle SQL extensions --
3. Understanding SQL execution --
4. Overivewof the SQL optimizers --
5. SQL internal processing --
6. Tuning SQL table access --
7. The steps to Oracle SQL tuning --
8. Understanding Oracle SQL utilities --
9. Locating significant SQL statements --
10. Tuning full-table scans and parallel query --
11. Optimizing sorting for Oracle SQL statements --
12. Tuning with Oracle hints --
13. Tuning with optimizer plan stability --
14. Tuning with the cost-based optimizer --
15. Tuning with the rule-based optimizer --
16. Tuning table joins --
17. Tuning SQL DML statements --
18. Tuning SQL with temporary tables --
19. Tuning SQL subqueries --
20. Tuning SQL with indexes --
21. Tuning data warehouse SQL --
22. SQL tuning with STATSPACK --
23. Tuning SQL with built-in functions and special operators.
Other Titles: Tune SQL statements for optimal execution
High-performance SQL tuning
Responsibility: Donald K. Burleson.
More information:

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/47920903> # Oracle high-performance SQL tuning
    a schema:Book, schema:CreativeWork ;
   library:oclcnum "47920903" ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/37113072#Place/berkeley_calif> ; # Berkeley, Calif.
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/cau> ;
   schema:about <http://id.worldcat.org/fast/1363816> ; # Oracle (Computer file)
   schema:about <http://experiment.worldcat.org/entity/work/data/37113072#CreativeWork/oracle_computer_file> ; # Oracle (Computer file)
   schema:about <http://id.worldcat.org/fast/1093575> ; # Relational databases
   schema:about <http://id.worldcat.org/fast/1102869> ; # SQL (Computer program language)
   schema:about <http://dewey.info/class/005.7585/e21/> ;
   schema:about <http://id.worldcat.org/fast/888037> ; # Database management
   schema:alternateName "High-performance SQL tuning" ;
   schema:alternateName "Tune SQL statements for optimal execution" ;
   schema:bookEdition "1st ed." ;
   schema:bookFormat bgn:PrintBook ;
   schema:copyrightYear "2001" ;
   schema:creator <http://viaf.org/viaf/32723157> ; # Donald K. Burleson
   schema:datePublished "2001" ;
   schema:description "1. Introduction to SQL -- 2. Overview of Oracle SQL extensions -- 3. Understanding SQL execution -- 4. Overivewof the SQL optimizers -- 5. SQL internal processing -- 6. Tuning SQL table access -- 7. The steps to Oracle SQL tuning -- 8. Understanding Oracle SQL utilities -- 9. Locating significant SQL statements -- 10. Tuning full-table scans and parallel query -- 11. Optimizing sorting for Oracle SQL statements -- 12. Tuning with Oracle hints -- 13. Tuning with optimizer plan stability -- 14. Tuning with the cost-based optimizer -- 15. Tuning with the rule-based optimizer -- 16. Tuning table joins -- 17. Tuning SQL DML statements -- 18. Tuning SQL with temporary tables -- 19. Tuning SQL subqueries -- 20. Tuning SQL with indexes -- 21. Tuning data warehouse SQL -- 22. SQL tuning with STATSPACK -- 23. Tuning SQL with built-in functions and special operators."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/37113072> ;
   schema:inLanguage "en" ;
   schema:name "Oracle high-performance SQL tuning"@en ;
   schema:productID "47920903" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/47920903#PublicationEvent/berkeley_calif_osborne_mcgraw_hill_2001> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/37113072#Agent/osborne_mcgraw_hill> ; # Osborne/McGraw-Hill
   schema:url <http://catdir.loc.gov/catdir/toc/mh023/2001275613.html> ;
   schema:workExample <http://worldcat.org/isbn/9780072190588> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/47920903> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/37113072#Agent/osborne_mcgraw_hill> # Osborne/McGraw-Hill
    a bgn:Agent ;
   schema:name "Osborne/McGraw-Hill" ;
    .

<http://experiment.worldcat.org/entity/work/data/37113072#CreativeWork/oracle_computer_file> # Oracle (Computer file)
    a schema:CreativeWork ;
   schema:name "Oracle (Computer file)" ;
    .

<http://experiment.worldcat.org/entity/work/data/37113072#Place/berkeley_calif> # Berkeley, Calif.
    a schema:Place ;
   schema:name "Berkeley, Calif." ;
    .

<http://id.worldcat.org/fast/1093575> # Relational databases
    a schema:Intangible ;
   schema:name "Relational databases"@en ;
    .

<http://id.worldcat.org/fast/1102869> # SQL (Computer program language)
    a schema:Intangible ;
   schema:name "SQL (Computer program language)"@en ;
    .

<http://id.worldcat.org/fast/1363816> # Oracle (Computer file)
    a schema:CreativeWork ;
   schema:name "Oracle (Computer file)" ;
    .

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
   schema:name "Database management"@en ;
    .

<http://viaf.org/viaf/32723157> # Donald K. Burleson
    a schema:Person ;
   schema:familyName "Burleson" ;
   schema:givenName "Donald K." ;
   schema:name "Donald K. Burleson" ;
    .

<http://worldcat.org/isbn/9780072190588>
    a schema:ProductModel ;
   schema:isbn "0072190582" ;
   schema:isbn "9780072190588" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.