3 Tables and Indexes are created
4 Total Tuples inserted is 1000
5 Tuples inserted into table
6 Case 1: -T option for t1: with 1000 tuple
7 Tables and Indexes are created
9 <TableName> t1 </TableName>
10 <TupleCount> 1000 </TupleCount>
11 <PagesUsed> 3 </PagesUsed>
12 <SpaceUsed> 24072 </SpaceUsed>
14 <TupleLength> 16 </TupleLength>
17 <IndexName> t1idx1 </IndexName>
20 Case 2: -I option for idx1 of t1, with 1000 tuple
22 <IndexName> t1idx1 </IndexName>
24 <Type> Hash Index </Type>
26 <TotalPages> 1 </TotalPages>
27 <TotalBuckets> 1009 </TotalBuckets>
30 <TotalPages> 4 </TotalPages>
31 <TotalNodes> 1000 </TotalNodes>
34 Total Tuples deleted is 1000
35 Tuples deleted from table
36 Case 3: -T option for t1: after removing 1000 tuple
38 <TableName> t1 </TableName>
39 <TupleCount> 0 </TupleCount>
40 <PagesUsed> 3 </PagesUsed>
41 <SpaceUsed> 72 </SpaceUsed>
43 <TupleLength> 16 </TupleLength>
46 <IndexName> t1idx1 </IndexName>
49 Case 4: -I option for idx1 of t1, after removing 1000 tuple
51 <IndexName> t1idx1 </IndexName>
53 <Type> Hash Index </Type>
55 <TotalPages> 1 </TotalPages>
56 <TotalBuckets> 1009 </TotalBuckets>
59 <TotalPages> 4 </TotalPages>
60 <TotalNodes> 0 </TotalNodes>
64 Tables and Indexes are dropped