资源描述：
《addison wesley - sql performance tuning》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。
1、SQLPerformanceTuningByPeterGulutzan,TrudyPelzerPublisher:AddisonWesleyPubDate:September10,2002ISBN:0-201-79169-2Pages:528SQLPerformanceTuningisahandbookofpracticalsolutionsforbusydatabaseprofessionalschargedwithmanaginganorganization'scriticallyimportantdata.Coveringtoday'smos
2、tpopularandwidelyinstalleddatabaseenvironments,thisbookisanindispensableresourceformanagingandtuningSQLacrossmultipleplatforms.Packedwithtips,techniques,andbestpractices,thishands-onguidecoversSQLcommandsandqueriesoverawiderangeofconditionsandenvironments.EveryfacetoftheSQLenv
3、ironmentiscovered,fromconcurrencycontroltooptimization—andeveryissueinbetween.Thebookincludesanoverviewofeachofthemostwidelyuseddatabasemanagementsystems(DBMS)andprovidestuningtipsforcommonday-to-daysituations.Topicscoveredinclude:•Generalandspecifictuning•Generalsortconsidera
4、tionsandoptions•Joinsandsubqueries•Columnsandtables•Indexes,includingB-treesandbitmaps•Constraintsandstoredprocedures•ODBCandJDBC•Datachangesandconcurrencycontrol(locking)•Clients,servers,andmiddlewareWhetheryouareaprogrammer,consultant,oruser,youwillfindSQLPerformanceTuningan
5、indispensableguidetooptimizingSQLperformanceacrosstoday'spopulardatabaseenvironments.ThroughoutSQLPerformanceTuning,ideasandtechniquesaretestedonavarietyofpopularSQLenvironments,includingIBMDB2,Informix,Ingres,InterBase,MicrosoftSQLServer,MySQL,Oracle,andSybaseASE.Thebook'spra
6、cticalexamplesarewritteninANSI/ISOStandardSQL:1999.CopyrightPrefaceYouDon'tKnowthatYourDBMSIsGood…YouKnowthatEvenGoodToolsWorkBetterinSkilledHands…AcknowledgmentsChapter1.FacilisDescensusAverniThisSubjectIsImportantTheBigEightTestResultsPortabilityTerminologyandExpectationsGen
7、eralitiesChapter2.SimpleSearchesGeneralTuningSpecificTuningStyleNotesPartingShotsChapter3.ORDERBYGeneralSortConsiderationsCharacterSortsOtherOptionsPartingShotsChapter4.GROUPBYRefresherOptimalGROUPBYClausesSortingSetFunctionsandSummaryAggregatesPartingShotsChapter5.JoinsJoinPl
8、anStrategiesAvoidtheJoinStrategiesThree-WayJoinsandBeyondOldS
