資源描述：
《addison wesley - sql performance tuning》由會員上傳分享，免費在線閱讀，更多相關內(nèi)容在學術論文-天天文庫。
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
