数据库原理电子教案全套课件.pptx

SQL Server 2000Storage and Access MethodsDon VilenProgram ManagerSQL Server Development Team AgendaSQL Server OverviewSQL Server ArchitectureStorage and Access MethodsQuery Processing and OptimizationTransaction ProcessingOther Topics Storage and Access Methods Storage and Access MethodsHeap – A table with no Clustered IndexGeneral Index StructureClustered and Non-clustered IndexesCovering Indexes Index IntersectionFillfactor and PerformanceIndex ReorganizationLocking and Indexes Heap – A Table with no Clustered IndexHeapExtent 160Extent 168Extent 176010203……SmithOtaJones…...……AkhtarFunkSmithMartin...………010203……RuddWhiteBarr………010203……ConFunkWhite………010203……SmithOtaJones…...……AkhtarFunkSmithMartin...………010203……RuddWhiteBarr………0102030405ConFunkWhiteDurkinLang………010203……SmithOtaJones…...……AkhtarFunkSmithMartin...………010203……RuddWhiteBarr………010203……ConFunkWhite………010203……SmithOtaJones…...……AkhtarFunkSmithMartin...………010203……RuddWhiteBarr………0102030405DunnRandallOtaSlichterLaBrie………010203……SmithOtaJones…...……AkhtarFunkSmithMartin...………010203……RuddWhiteBarr………010203……ConFunkWhite………010203……SmithOtaJones…...……AkhtarFunkSmithMartin...………010203……RuddWhiteBarr………010203……SmithOtaJones…...……AkhtarFunkSmithMartin...………010203……RuddWhiteBarr………010203……ConFunkWhite………010203……SmithOtaJones…...……AkhtarFunkSmithMartin...………010203……RuddWhiteBarr………010203……GraffBaconKoch………ExtentSeattleParisTokyoAtlanta...………IAM…160 1168 1176 0184 1…Extent Bit Mapidindid = 0First IAMsysindexes General Index StructurePage 140 - RootPage 141Page 145AkhtarGanio…Akhtar…MartinMartinSmith…Node Pagesidindid = xrootsysindexesPage 100 Page 120 Page 130 AkhtarBarrConFunkFunk...23345678253413341534MartinMartinOtaPhuaRudd...12347778587878786078SmithSmithSmithWhiteWhite...14345778797822341634Page 110 GanioHallJonesJonesJones...76788078243459782634LeafPages Clustered and Noncl