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
>
24 <TotalPages
> 1 </TotalPages
>
25 <TotalBuckets
> 1009 </TotalBuckets
>
28 <TotalPages
> 1 </TotalPages
>
29 <TotalNodes
> 1 </TotalNodes
>
32 Total Tuples deleted is
1
33 Tuples deleted from table
34 Case
3: -T option
for t1
: after removing
1 tuple
36 <TableName
> t1
</TableName
>
37 <TupleCount
> 0 </TupleCount
>
38 <PagesUsed
> 1 </PagesUsed
>
39 <SpaceUsed
> 16 </SpaceUsed
>
41 <TupleLength
> 12 </TupleLength
>
44 <IndexName
> t1idx1
</IndexName
>
47 Case
4: -I option
for idx1 of t1
, after removing
1 tuple
49 <IndexName
> t1idx1
</IndexName
>
52 <TotalPages
> 1 </TotalPages
>
53 <TotalBuckets
> 1009 </TotalBuckets
>
56 <TotalPages
> 1 </TotalPages
>
57 <TotalNodes
> 0 </TotalNodes
>
61 Tables and Indexes are dropped