(精编)Index Blocking Factors, Views教学课件.pptVIP

Index Blocking Factors, Views Rose-Hulman Institute of Technology Curt Clifton Index Redux Heap storage Clustered (primary) index Non-clustered (secondary) index On heap stored table On clustered table Index Calculations To understand index, helpful to calculate sizes Terms: Blocking factor: How many records fit on a page (a.k.a., a block) – see Q1a Index block factor: How many index entries fit on a page – see Q1b Index Calculations (cont.) Single level index… If primary (clustered), then one entry for each block in file If secondary, then one entry for each entry in file See Q1c Multi-leve