Oracle SQL Tuning with Oracle SQLTXPLAIN

Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge l...

Full description

Bibliographic Details
Main Author: Charalambides, Stelios. (Author)
Corporate Author: SpringerLink (Online service)
Format: Electronic
Language:English
Published: Berkeley, CA : Apress : Imprint: Apress, 2013.
Subjects:
Online Access:https://ezaccess.library.uitm.edu.my/login?url=http://dx.doi.org/10.1007/978-1-4302-4810-1
LEADER 02113nam a22003975i 4500
001 12282
003 DE-He213
005 20130727074913.0
007 cr nn 008mamaa
008 130414s2013 xxu| s |||| 0|eng d
020 # # |a 9781430248101  |9 978-1-4302-4810-1 
024 7 # |a 10.1007/978-1-4302-4810-1  |2 doi 
050 # 4 |a QA76.9.D3 
072 # 7 |a UN  |2 bicssc 
072 # 7 |a UMT  |2 bicssc 
072 # 7 |a COM021000  |2 bisacsh 
082 0 4 |a 005.74  |2 23 
100 1 # |a Charalambides, Stelios.  |e author. 
245 1 0 |a Oracle SQL Tuning with Oracle SQLTXPLAIN  |c by Stelios Charalambides.  |h [electronic resource] / 
264 # 1 |a Berkeley, CA :  |b Apress :  |b Imprint: Apress,  |c 2013. 
300 # # |a XXV, 344 p.  |b online resource. 
336 # # |a text  |b txt  |2 rdacontent 
337 # # |a computer  |b c  |2 rdamedia 
338 # # |a online resource  |b cr  |2 rdacarrier 
347 # # |a text file  |b PDF  |2 rda 
520 # # |a Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole. Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and when it's better to turn them off. Quickly tune any SQL statement no matter how complex. Build and tune test cases without affecting production. Use the latest tuning features with confidence. 
650 # 0 |a Computer science. 
650 # 0 |a Database management. 
650 1 4 |a Computer Science. 
650 2 4 |a Database Management. 
710 2 # |a SpringerLink (Online service) 
773 0 # |t Springer eBooks 
776 0 8 |i Printed edition:  |z 9781430248095 
856 4 0 |u https://ezaccess.library.uitm.edu.my/login?url=http://dx.doi.org/10.1007/978-1-4302-4810-1 
912 # # |a ZDB-2-CWD 
950 # # |a Professional and Applied Computing (Springer-12059)