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
> 32 </SpaceUsed
>
13 <TupleLength
> 12 </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
> 16 </SpaceUsed
>
42 <TupleLength
> 12 </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