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
> 2 </PagesUsed
>
12 <SpaceUsed
> 16032 </SpaceUsed
>
14 <TupleLength
> 12 </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
> 2 </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
> 2 </PagesUsed
>
41 <SpaceUsed
> 32 </SpaceUsed
>
43 <TupleLength
> 12 </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
> 2 </TotalPages
>
60 <TotalNodes
> 0 </TotalNodes
>
64 Tables and Indexes are dropped