| Record ID | marc_nuls/NULS_PHC_180925.mrc:227760095:2500 |
| Source | marc_nuls |
| Download Link | /show-records/marc_nuls/NULS_PHC_180925.mrc:227760095:2500?format=raw |
LEADER: 02500pam 2200277 a 4500
001 9921642840001661
005 20150423135539.0
008 030127s2002 enk 000 0 eng
015 $aGBA1-V1578
020 $a0596002688
029 0 $aUKM$bbA1V1578
035 $a(CSdNU)u109921-01national_inst
035 $a(OCoLC)48154355
035 $a(Sirsi) 01-AAP-2435
040 $aUKM$cUKM$dCUS$dOrPss
049 $aCNUM
090 $aQA76.73.S67$bG87 2002
100 1 $aGurry, Mark.
245 10 $aOracle SQL tuning :$bpocket reference /$cMark Gurry.
260 $aBeijing :$aFarnham :$bO'Reilly,$c2002.
300 $avi, 102 p. ;$c18 cm.
505 0 $aThe SQL Optimizers -- Understanding the Rule-Based Optimizer -- Understanding the Cost-Based Optimizer -- Some Common Optimizer Misconceptions -- Which Optimizer to Use? -- Rule-Based Optimizer Problems and Solutions -- Incorrect Driving Table -- Incorrect Index -- Incorrect Driving Index -- Using the Order By Index and not the Where Index -- Cost-Based Optimizer Problems and Solutions -- The Skewness Problem -- Analyzing with Wrong Data -- Mixing the Optimizers in Joins -- Choosing an Inferior Index -- Joining Too Many Tables -- Incorrect Init. Ora Parameter Settings -- Problems Common to Rule and Cost with Solutions -- Statement Not Written for Indexes -- Indexes Are Missing or Inappropriate -- Use of Single-Column Index Merge -- Misuse of Nested Loop, Sort Merge, or Hash Join -- Misuse of in, Exists, Not in, Not Exists, or Table Joins -- Unnecessary Sorts -- Too Many Indexes on a Table -- Use of Or Instead of Union -- Tables and Indexes with Many Deletes -- Other Problems: Heavy Usage of Views -- Other Problems: Joining Too Many Tables -- Handy SQL Tuning Tips -- Identify Bad SQL -- Identify Long-Running SQL Statements -- Use Decode for If/Else Selection -- Encourage Bind Variables -- Using SQL Hints -- When Are Hints Ignored? -- Using Hints in Views -- Available Hints -- Using DBMS_STATS to Manage Statistics -- Using DBMS_STATS to Analyze Faster -- Copying Statistics Using DBMS_STATS -- Manipulating Statistics Using DBMS_STATS -- Reverting to Previous Statistics -- Using Outlines for Consistent Execution Plans -- Recording Outlines -- Enabling Outlines -- Managing Outlines.
650 0 $aSQL (Computer program language)
948 $a02/04/2003$b02/26/2003
982 0 $aQA76.73.S67$aG87$a2002
999 $aQA 76.73 S67 G87 2002$wLC$c1$i31786101556923$d2/17/2011$f6/22/2004$g1 $lCIRCSTACKS$mNULS$q1$rY$sY$tBOOK$u2/26/2003