3 Tables and Indexes are created
4 Total Tuples inserted is 1
5 Tuples inserted into table
6 Case 1: -T option for t1: with 1 tuple
8 <TableName> t1 </TableName>
9 <TupleCount> 1 </TupleCount>
10 <PagesUsed> 1 </PagesUsed>
11 <SpaceUsed> 48 </SpaceUsed>
13 <TupleLength> 16 </TupleLength>
16 <IndexName> t1idx1 </IndexName>
19 Case 2: -I option for idx1 of t1, with 1 tuple
21 <IndexName> t1idx1 </IndexName>
23 <Type> Hash Index </Type>
25 <TotalPages> 1 </TotalPages>
26 <TotalBuckets> 1009 </TotalBuckets>
29 <TotalPages> 1 </TotalPages>
30 <TotalNodes> 1 </TotalNodes>
33 Total Tuples deleted is 1
34 Tuples deleted from table
35 Case 3: -T option for t1: after removing 1 tuple
37 <TableName> t1 </TableName>
38 <TupleCount> 0 </TupleCount>
39 <PagesUsed> 1 </PagesUsed>
40 <SpaceUsed> 24 </SpaceUsed>
42 <TupleLength> 16 </TupleLength>
45 <IndexName> t1idx1 </IndexName>
48 Case 4: -I option for idx1 of t1, after removing 1 tuple
50 <IndexName> t1idx1 </IndexName>
52 <Type> Hash Index </Type>
54 <TotalPages> 1 </TotalPages>
55 <TotalBuckets> 1009 </TotalBuckets>
58 <TotalPages> 1 </TotalPages>
59 <TotalNodes> 0 </TotalNodes>
63 Tables and Indexes are dropped